<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>XSSFSheet (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="XSSFSheet (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/XSSFSheet.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFShapeGroup.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheetConditionalFormatting.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/xssf/usermodel/XSSFSheet.html" target="_top">FRAMES</a></li>
<li><a href="XSSFSheet.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<p class="subTitle">org.apache.poi.xssf.usermodel</p>
<h2 title="Class XSSFSheet" class="title">Class XSSFSheet</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">org.apache.poi.POIXMLDocumentPart</a></li>
<li>
<ul class="inheritance">
<li>org.apache.poi.xssf.usermodel.XSSFSheet</li>
</ul>
</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd>java.lang.Iterable&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></dd>
</dl>
<dl>
<dt>Direct Known Subclasses:</dt>
<dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFChartSheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFChartSheet</a>, <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDialogsheet.html" title="class in org.apache.poi.xssf.usermodel">XSSFDialogsheet</a></dd>
</dl>
<hr>
<br>
<pre>public class <strong>XSSFSheet</strong>
extends <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a>
implements <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></pre>
<div class="block">High level representation of a SpreadsheetML worksheet.

 <p>
 Sheets are the central structures within a workbook, and are where a user does most of his spreadsheet work.
 The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can
 contain text, numbers, dates, and formulas. Cells can also be formatted.
 </p></div>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_summary">
<!--   -->
</a>
<h3>Field Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#sheet">sheet</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#worksheet">worksheet</a></strong></code>&nbsp;</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="fields_inherited_from_class_org.apache.poi.POIXMLDocumentPart">
<!--   -->
</a>
<h3>Fields inherited from class&nbsp;org.apache.poi.<a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></h3>
<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#DEFAULT_XML_OPTIONS">DEFAULT_XML_OPTIONS</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="fields_inherited_from_class_org.apache.poi.ss.usermodel.Sheet">
<!--   -->
</a>
<h3>Fields inherited from interface&nbsp;org.apache.poi.ss.usermodel.<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></h3>
<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#BottomMargin">BottomMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#FooterMargin">FooterMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#HeaderMargin">HeaderMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#LeftMargin">LeftMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_LOWER_LEFT">PANE_LOWER_LEFT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_LOWER_RIGHT">PANE_LOWER_RIGHT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_UPPER_LEFT">PANE_UPPER_LEFT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_UPPER_RIGHT">PANE_UPPER_RIGHT</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#RightMargin">RightMargin</a>, <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#TopMargin">TopMargin</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_summary">
<!--   -->
</a>
<h3>Constructor Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier</th>
<th class="colLast" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected </code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#XSSFSheet()">XSSFSheet</a></strong>()</code>
<div class="block">Creates new XSSFSheet   - called by XSSFWorkbook to create a sheet from scratch.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected </code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#XSSFSheet(org.apache.poi.openxml4j.opc.PackagePart, org.apache.poi.openxml4j.opc.PackageRelationship)">XSSFSheet</a></strong>(<a href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html" title="class in org.apache.poi.openxml4j.opc">PackagePart</a>&nbsp;part,
         <a href="../../../../../org/apache/poi/openxml4j/opc/PackageRelationship.html" title="class in org.apache.poi.openxml4j.opc">PackageRelationship</a>&nbsp;rel)</code>
<div class="block">Creates an XSSFSheet representing the given package part and relationship.</div>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#addHyperlink(org.apache.poi.xssf.usermodel.XSSFHyperlink)">addHyperlink</a></strong>(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a>&nbsp;hyperlink)</code>
<div class="block">Register a hyperlink in the collection of hyperlinks on this sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region)</code>
<div class="block">Adds a merged region of cells (hence those cells form one).</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">addValidationData</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a>&nbsp;dataValidation)</code>
<div class="block">Creates a data validation object</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#autoSizeColumn(int)">autoSizeColumn</a></strong>(int&nbsp;column)</code>
<div class="block">Adjusts the column width to fit the contents.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#autoSizeColumn(int, boolean)">autoSizeColumn</a></strong>(int&nbsp;column,
              boolean&nbsp;useMergedCells)</code>
<div class="block">Adjusts the column width to fit the contents.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#commit()">commit</a></strong>()</code>
<div class="block">Save the content in the underlying package part.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createComment()">createComment</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>since Nov 2009 this method is not compatible with the common SS interfaces,
 use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDrawing.html#createCellComment(org.apache.poi.ss.usermodel.ClientAnchor)"><code>(org.apache.poi.ss.usermodel.ClientAnchor)</code></a> instead</i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDrawing.html" title="class in org.apache.poi.xssf.usermodel">XSSFDrawing</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createDrawingPatriarch()">createDrawingPatriarch</a></strong>()</code>
<div class="block">Create a new SpreadsheetML drawing.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createFreezePane(int, int)">createFreezePane</a></strong>(int&nbsp;colSplit,
                int&nbsp;rowSplit)</code>
<div class="block">Creates a split (freezepane).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createFreezePane(int, int, int, int)">createFreezePane</a></strong>(int&nbsp;colSplit,
                int&nbsp;rowSplit,
                int&nbsp;leftmostColumn,
                int&nbsp;topRow)</code>
<div class="block">Creates a split (freezepane).</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.util.AreaReference, org.apache.poi.ss.util.CellReference)">createPivotTable</a></strong>(<a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;position)</code>
<div class="block">Create a pivot table and set area of source and a position for pivot table</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createPivotTable(org.apache.poi.ss.util.AreaReference, org.apache.poi.ss.util.CellReference, org.apache.poi.ss.usermodel.Sheet)">createPivotTable</a></strong>(<a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;position,
                <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</code>
<div class="block">Create a pivot table and set area of source, source sheet and a position for pivot table</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createRow(int)">createRow</a></strong>(int&nbsp;rownum)</code>
<div class="block">Create a new row within the sheet and return the high level representation</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createSplitPane(int, int, int, int, int)">createSplitPane</a></strong>(int&nbsp;xSplitPos,
               int&nbsp;ySplitPos,
               int&nbsp;leftmostColumn,
               int&nbsp;topRow,
               int&nbsp;activePane)</code>
<div class="block">Creates a split pane.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#createTable()">createTable</a></strong>()</code>
<div class="block">Creates a new Table, and associates it with this Sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()">disableLocking</a></strong>()</code>
<div class="block">Disable sheet protection</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()">enableLocking</a></strong>()</code>
<div class="block">Enable sheet protection</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#findEndOfRowOutlineGroup(int)">findEndOfRowOutlineGroup</a></strong>(int&nbsp;row)</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getActiveCell()">getActiveCell</a></strong>()</code>
<div class="block">Return location of the active cell, e.g.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getAutobreaks()">getAutobreaks</a></strong>()</code>
<div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCellComment(int, int)">getCellComment</a></strong>(int&nbsp;row,
              int&nbsp;column)</code>
<div class="block">Returns cell comment for the specified row and column</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnBreaks()">getColumnBreaks</a></strong>()</code>
<div class="block">Vertical page break information used for print layout view, page layout view, drawing print breaks
 in normal view, and for printing the worksheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/helpers/ColumnHelper.html" title="class in org.apache.poi.xssf.usermodel.helpers">ColumnHelper</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnHelper()">getColumnHelper</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnStyle(int)">getColumnStyle</a></strong>(int&nbsp;column)</code>
<div class="block">Returns the CellStyle that applies to the given
  (0 based) column, or null if no style has been
  set for that column</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnWidth(int)">getColumnWidth</a></strong>(int&nbsp;columnIndex)</code>
<div class="block">Get the actual column width (in units of 1/256th of a character width )</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>float</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></strong>(int&nbsp;columnIndex)</code>
<div class="block">Get the actual column width in pixels</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="../../../../../org/apache/poi/xssf/model/CommentsTable.html" title="class in org.apache.poi.xssf.model">CommentsTable</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCommentsTable(boolean)">getCommentsTable</a></strong>(boolean&nbsp;create)</code>
<div class="block">Returns the sheet's comments object if there is one,
  or null if not</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDrawing</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTDrawing()">getCTDrawing</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTLegacyDrawing</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTLegacyDrawing()">getCTLegacyDrawing</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getCTWorksheet()">getCTWorksheet</a></strong>()</code>
<div class="block">Provide access to the CTWorksheet bean holding this sheet's data</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel">DataValidationHelper</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDataValidationHelper()">getDataValidationHelper</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidation.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidation</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDataValidations()">getDataValidations</a></strong>()</code>
<div class="block">Returns the list of DataValidation in the sheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a></strong>()</code>
<div class="block">Get the default column width for the sheet (if the columns do not define their own width) in
 characters.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDefaultRowHeight()">getDefaultRowHeight</a></strong>()</code>
<div class="block">Get the default row height for the sheet (if the rows do not define their own height) in
 twips (1/20 of  a point)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>float</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a></strong>()</code>
<div class="block">Get the default row height for the sheet measued in point size (if the rows do not define their own height).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDisplayGuts()">getDisplayGuts</a></strong>()</code>
<div class="block">Get whether to display the guts or not,
 default value is true</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getEvenFooter()">getEvenFooter</a></strong>()</code>
<div class="block">Returns the even footer.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getEvenHeader()">getEvenHeader</a></strong>()</code>
<div class="block">Returns the even header.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFirstFooter()">getFirstFooter</a></strong>()</code>
<div class="block">Returns the first page footer.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFirstHeader()">getFirstHeader</a></strong>()</code>
<div class="block">Returns the first page header.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFirstRowNum()">getFirstRowNum</a></strong>()</code>
<div class="block">Gets the first row on the sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFitToPage()">getFitToPage</a></strong>()</code>
<div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFooter()">getFooter</a></strong>()</code>
<div class="block">Returns the default footer for the sheet,
  creating one as needed.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></strong>()</code>
<div class="block">Whether Excel will be asked to recalculate all formulas when the
  workbook is opened.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getHeader()">getHeader</a></strong>()</code>
<div class="block">Returns the default header for the sheet,
  creating one as needed.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getHorizontallyCenter()">getHorizontallyCenter</a></strong>()</code>
<div class="block">Determine whether printed output for this sheet will be horizontally centered.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getHyperlink(int, int)">getHyperlink</a></strong>(int&nbsp;row,
            int&nbsp;column)</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getLastRowNum()">getLastRowNum</a></strong>()</code>
<div class="block">Gets the last row on the sheet</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getLeftCol()">getLeftCol</a></strong>()</code>
<div class="block">The left col in the visible view when the sheet is
 first viewed after opening it in a viewer</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>double</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getMargin(short)">getMargin</a></strong>(short&nbsp;margin)</code>
<div class="block">Gets the size of the margin in inches.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getMergedRegion(int)">getMergedRegion</a></strong>(int&nbsp;index)</code>
<div class="block">Returns the merged region at the specified index</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getNumberOfComments()">getNumberOfComments</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getNumHyperlinks()">getNumHyperlinks</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getNumMergedRegions()">getNumMergedRegions</a></strong>()</code>
<div class="block">Returns the number of merged regions defined in this worksheet</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getOddFooter()">getOddFooter</a></strong>()</code>
<div class="block">Returns the odd footer.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getOddHeader()">getOddHeader</a></strong>()</code>
<div class="block">Returns the odd header.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/hssf/util/PaneInformation.html" title="class in org.apache.poi.hssf.util">PaneInformation</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPaneInformation()">getPaneInformation</a></strong>()</code>
<div class="block">Returns the information regarding the currently configured pane (split or freeze).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>int</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a></strong>()</code>
<div class="block">Returns the number of physically defined rows (NOT the number of rows in the sheet)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPivotTables()">getPivotTables</a></strong>()</code>
<div class="block">Returns all the pivot tables for this Sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPrintSetup.html" title="class in org.apache.poi.xssf.usermodel">XSSFPrintSetup</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getPrintSetup()">getPrintSetup</a></strong>()</code>
<div class="block">Gets the print setup object.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getProtect()">getProtect</a></strong>()</code>
<div class="block">Answer whether protection is enabled or disabled</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRepeatingColumns()">getRepeatingColumns</a></strong>()</code>
<div class="block">Gets the repeating columns used when printing the sheet, as found in 
 File->PageSetup->Sheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRepeatingRows()">getRepeatingRows</a></strong>()</code>
<div class="block">Gets the repeating rows used when printing the sheet, as found in 
 File->PageSetup->Sheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRow(int)">getRow</a></strong>(int&nbsp;rownum)</code>
<div class="block">Returns the logical row ( 0-based).</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>int[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRowBreaks()">getRowBreaks</a></strong>()</code>
<div class="block">Horizontal page break information used for print layout view, page layout view, drawing print breaks in normal
  view, and for printing the worksheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRowSumsBelow()">getRowSumsBelow</a></strong>()</code>
<div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getRowSumsRight()">getRowSumsRight</a></strong>()</code>
<div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getScenarioProtect()">getScenarioProtect</a></strong>()</code>
<div class="block">A flag indicating whether scenarios are locked when the sheet is protected.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getSharedFormula(int)">getSharedFormula</a></strong>(int&nbsp;sid)</code>
<div class="block">Return a master shared formula by index</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheetConditionalFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheetConditionalFormatting</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></strong>()</code>
<div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getSheetName()">getSheetName</a></strong>()</code>
<div class="block">Returns the name of this sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFTable</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getTables()">getTables</a></strong>()</code>
<div class="block">Returns any tables associated with this Sheet</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getTopRow()">getTopRow</a></strong>()</code>
<div class="block">The top row in the visible view when the sheet is
 first viewed after opening it in a viewer</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getVerticallyCenter()">getVerticallyCenter</a></strong>()</code>
<div class="block">Determine whether printed output for this sheet will be vertically centered.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFVMLDrawing.html" title="class in org.apache.poi.xssf.usermodel">XSSFVMLDrawing</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getVMLDrawing(boolean)">getVMLDrawing</a></strong>(boolean&nbsp;autoCreate)</code>
<div class="block">Get VML drawing for this sheet (aka 'legacy' drawig)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getWorkbook()">getWorkbook</a></strong>()</code>
<div class="block">Returns the parent XSSFWorkbook</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#groupColumn(int, int)">groupColumn</a></strong>(int&nbsp;fromColumn,
           int&nbsp;toColumn)</code>
<div class="block">Group between (0 based) columns</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#groupRow(int, int)">groupRow</a></strong>(int&nbsp;fromRow,
        int&nbsp;toRow)</code>
<div class="block">Tie a range of cell together so that they can be collapsed or expanded</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#hasComments()">hasComments</a></strong>()</code>
<div class="block">Does this sheet have any comments on it? We need to know,
  so we can decide about writing it to disk or not</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isAutoFilterLocked()">isAutoFilterLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isColumnBroken(int)">isColumnBroken</a></strong>(int&nbsp;column)</code>
<div class="block">Determines if there is a page break at the indicated column</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isColumnHidden(int)">isColumnHidden</a></strong>(int&nbsp;columnIndex)</code>
<div class="block">Get the hidden state for a given column.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDeleteColumnsLocked()">isDeleteColumnsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDeleteRowsLocked()">isDeleteRowsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDisplayFormulas()">isDisplayFormulas</a></strong>()</code>
<div class="block">Gets the flag indicating whether this sheet should display formulas.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDisplayGridlines()">isDisplayGridlines</a></strong>()</code>
<div class="block">Gets the flag indicating whether this sheet displays the lines
 between rows and columns to make editing and reading easier.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></strong>()</code>
<div class="block">Gets the flag indicating whether this sheet should display row and column headings.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isDisplayZeros()">isDisplayZeros</a></strong>()</code>
<div class="block">Gets the flag indicating whether the window should show 0 (zero) in cells containing zero value.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isFormatCellsLocked()">isFormatCellsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isFormatColumnsLocked()">isFormatColumnsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isFormatRowsLocked()">isFormatRowsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isInsertColumnsLocked()">isInsertColumnsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isInsertHyperlinksLocked()">isInsertHyperlinksLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isInsertRowsLocked()">isInsertRowsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isObjectsLocked()">isObjectsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isPivotTablesLocked()">isPivotTablesLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isPrintGridlines()">isPrintGridlines</a></strong>()</code>
<div class="block">Returns whether gridlines are printed.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isRightToLeft()">isRightToLeft</a></strong>()</code>
<div class="block">Whether the text is displayed in right-to-left mode in the window</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isRowBroken(int)">isRowBroken</a></strong>(int&nbsp;row)</code>
<div class="block">Tests if there is a page break at the indicated row</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isScenariosLocked()">isScenariosLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isSelected()">isSelected</a></strong>()</code>
<div class="block">Returns a flag indicating whether this sheet is selected.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isSelectLockedCellsLocked()">isSelectLockedCellsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isSelectUnlockedCellsLocked()">isSelectUnlockedCellsLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isSheetLocked()">isSheetLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isSortLocked()">isSortLocked</a></strong>()</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.util.Iterator&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#iterator()">iterator</a></strong>()</code>
<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#rowIterator()"><code>rowIterator()</code></a> to
  allow foreach loops</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockAutoFilter()">lockAutoFilter</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockAutoFilter(boolean)"><code>lockAutoFilter(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockAutoFilter(boolean)">lockAutoFilter</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Autofilters locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteColumns()">lockDeleteColumns</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteColumns(boolean)"><code>lockDeleteColumns(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteColumns(boolean)">lockDeleteColumns</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Deleting columns locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteRows()">lockDeleteRows</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteRows(boolean)"><code>lockDeleteRows(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteRows(boolean)">lockDeleteRows</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Deleting rows locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatCells()">lockFormatCells</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatCells(boolean)"><code>lockFormatCells(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatCells(boolean)">lockFormatCells</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Formatting cells locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatColumns()">lockFormatColumns</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatColumns(boolean)"><code>lockFormatColumns(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatColumns(boolean)">lockFormatColumns</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Formatting columns locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatRows()">lockFormatRows</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatRows(boolean)"><code>lockFormatRows(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatRows(boolean)">lockFormatRows</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Formatting rows locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertColumns()">lockInsertColumns</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertColumns(boolean)"><code>lockInsertColumns(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertColumns(boolean)">lockInsertColumns</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Inserting columns locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks()">lockInsertHyperlinks</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks(boolean)"><code>lockInsertHyperlinks(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks(boolean)">lockInsertHyperlinks</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Inserting hyperlinks locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertRows()">lockInsertRows</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertRows(boolean)"><code>lockInsertRows(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertRows(boolean)">lockInsertRows</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Inserting rows locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockObjects()">lockObjects</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockObjects(boolean)"><code>lockObjects(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockObjects(boolean)">lockObjects</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Objects locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockPivotTables()">lockPivotTables</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockPivotTables(boolean)"><code>lockPivotTables(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockPivotTables(boolean)">lockPivotTables</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Pivot Tables locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockScenarios()">lockScenarios</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockScenarios(boolean)"><code>lockScenarios(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockScenarios(boolean)">lockScenarios</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Scenarios locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells()">lockSelectLockedCells</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells(boolean)"><code>lockSelectLockedCells(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells(boolean)">lockSelectLockedCells</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Selection of locked cells locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells()">lockSelectUnlockedCells</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells(boolean)"><code>lockSelectUnlockedCells(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells(boolean)">lockSelectUnlockedCells</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Selection of unlocked cells locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSort()">lockSort</a></strong>()</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSort(boolean)"><code>lockSort(boolean)</code></a></i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSort(boolean)">lockSort</a></strong>(boolean&nbsp;enabled)</code>
<div class="block">Enable or disable Sort locking.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#onDocumentCreate()">onDocumentCreate</a></strong>()</code>
<div class="block">Initialize worksheet data when creating a new sheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#onDocumentRead()">onDocumentRead</a></strong>()</code>
<div class="block">Initialize worksheet data when reading in an exisiting file.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#protectSheet(java.lang.String)">protectSheet</a></strong>(java.lang.String&nbsp;password)</code>
<div class="block">Enables sheet protection and sets the password for the sheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#read(java.io.InputStream)">read</a></strong>(java.io.InputStream&nbsp;is)</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&nbsp;cell)</code>
<div class="block">Remove a Array Formula from this sheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeColumnBreak(int)">removeColumnBreak</a></strong>(int&nbsp;column)</code>
<div class="block">Removes a page break at the indicated column</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeHyperlink(int, int)">removeHyperlink</a></strong>(int&nbsp;row,
               int&nbsp;column)</code>
<div class="block">Removes a hyperlink in the collection of hyperlinks on this sheet</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeMergedRegion(int)">removeMergedRegion</a></strong>(int&nbsp;index)</code>
<div class="block">Removes a merged region of cells (hence letting them free)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeMergedRegions(java.util.Set)">removeMergedRegions</a></strong>(java.util.Set&lt;java.lang.Integer&gt;&nbsp;indices)</code>
<div class="block">Removes a number of merged regions of cells (hence letting them free)

 This method can be used to bulk-remove merged regions in a way
 much faster than calling removeMergedRegion() for every single
 merged region.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row)</code>
<div class="block">Remove a row from this sheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeRowBreak(int)">removeRowBreak</a></strong>(int&nbsp;row)</code>
<div class="block">Removes the page break at the indicated row</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>java.util.Iterator&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#rowIterator()">rowIterator</a></strong>()</code>
<div class="block">Returns an iterator of the physical rows</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setActiveCell(java.lang.String)">setActiveCell</a></strong>(java.lang.String&nbsp;cellRef)</code>
<div class="block">Sets location of the active cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setArrayFormula(java.lang.String, org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></strong>(java.lang.String&nbsp;formula,
               <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</code>
<div class="block">Sets array formula to specified region for result.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setAutobreaks(boolean)">setAutobreaks</a></strong>(boolean&nbsp;value)</code>
<div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFAutoFilter.html" title="class in org.apache.poi.xssf.usermodel">XSSFAutoFilter</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</code>
<div class="block">Enable filtering for a range of cells</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setCellComment(java.lang.String, org.apache.poi.xssf.usermodel.XSSFComment)">setCellComment</a></strong>(java.lang.String&nbsp;cellRef,
              <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>&nbsp;comment)</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>since Nov 2009 use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html#setCellComment(org.apache.poi.ss.usermodel.Comment)"><code>XSSFCell.setCellComment(org.apache.poi.ss.usermodel.Comment)</code></a> instead</i></div>
</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnBreak(int)">setColumnBreak</a></strong>(int&nbsp;column)</code>
<div class="block">Sets a page break at the indicated column.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnGroupCollapsed(int, boolean)">setColumnGroupCollapsed</a></strong>(int&nbsp;columnNumber,
                       boolean&nbsp;collapsed)</code>
<div class="block">Expands or collapses a column group.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnHidden(int, boolean)">setColumnHidden</a></strong>(int&nbsp;columnIndex,
               boolean&nbsp;hidden)</code>
<div class="block">Get the visibility state for a given column.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setColumnWidth(int, int)">setColumnWidth</a></strong>(int&nbsp;columnIndex,
              int&nbsp;width)</code>
<div class="block">Set the width (in units of 1/256th of a character width)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultColumnStyle(int, org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></strong>(int&nbsp;column,
                     <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;style)</code>
<div class="block">Sets the default column style for a given column.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></strong>(int&nbsp;width)</code>
<div class="block">Specifies the number of characters of the maximum digit width of the normal style's font.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></strong>(short&nbsp;height)</code>
<div class="block">Set the default row height for the sheet (if the rows do not define their own height) in
 twips (1/20 of  a point)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></strong>(float&nbsp;height)</code>
<div class="block">Sets default row height measured in point size.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></strong>(boolean&nbsp;show)</code>
<div class="block">Sets the flag indicating whether this sheet should display formulas.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></strong>(boolean&nbsp;show)</code>
<div class="block">Sets the flag indicating whether this sheet should display the lines
 between rows and columns to make editing and reading easier.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></strong>(boolean&nbsp;value)</code>
<div class="block">Set whether to display the guts or not</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></strong>(boolean&nbsp;show)</code>
<div class="block">Sets the flag indicating whether this sheet should display row and column headings.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></strong>(boolean&nbsp;value)</code>
<div class="block">Set whether the window should show 0 (zero) in cells containing zero value.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setFitToPage(boolean)">setFitToPage</a></strong>(boolean&nbsp;b)</code>
<div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></strong>(boolean&nbsp;value)</code>
<div class="block">Control if Excel should be asked to recalculate all formulas on this sheet
 when the workbook is opened.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></strong>(boolean&nbsp;value)</code>
<div class="block">Center on page horizontally when printing.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setMargin(short, double)">setMargin</a></strong>(short&nbsp;margin,
         double&nbsp;size)</code>
<div class="block">Sets the size of the margin in inches.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></strong>(boolean&nbsp;value)</code>
<div class="block">Turns on or off the printing of gridlines.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;columnRangeRef)</code>
<div class="block">Sets the repeating columns used when printing the sheet, as found in 
 File->PageSetup->Sheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></strong>(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;rowRangeRef)</code>
<div class="block">Sets the repeating rows used when printing the sheet, as found in 
 File->PageSetup->Sheet.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRightToLeft(boolean)">setRightToLeft</a></strong>(boolean&nbsp;value)</code>
<div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRowBreak(int)">setRowBreak</a></strong>(int&nbsp;row)</code>
<div class="block">Sets a page break at the indicated row
 Breaks occur above the specified row and left of the specified column inclusive.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRowGroupCollapsed(int, boolean)">setRowGroupCollapsed</a></strong>(int&nbsp;rowIndex,
                    boolean&nbsp;collapse)</code>
<div class="block">group the row It is possible for collapsed to be false and yet still have
 the rows in question hidden.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></strong>(boolean&nbsp;value)</code>
<div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></strong>(boolean&nbsp;value)</code>
<div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setSelected(boolean)">setSelected</a></strong>(boolean&nbsp;value)</code>
<div class="block">Sets a flag indicating whether this sheet is selected.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setSheetPassword(java.lang.String, org.apache.poi.poifs.crypt.HashAlgorithm)">setSheetPassword</a></strong>(java.lang.String&nbsp;password,
                <a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a>&nbsp;hashAlgo)</code>
<div class="block">Sets the sheet password.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setTabColor(int)">setTabColor</a></strong>(int&nbsp;colorIndex)</code>
<div class="block">Set background color of the sheet tab</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></strong>(boolean&nbsp;value)</code>
<div class="block">Whether the output is vertically centered on the page.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setZoom(int)">setZoom</a></strong>(int&nbsp;scale)</code>
<div class="block">Window zoom magnification for current view representing percent values.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setZoom(int, int)">setZoom</a></strong>(int&nbsp;numerator,
       int&nbsp;denominator)</code>
<div class="block">Sets the zoom magnication for the sheet.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#shiftRows(int, int, int)">shiftRows</a></strong>(int&nbsp;startRow,
         int&nbsp;endRow,
         int&nbsp;n)</code>
<div class="block">Shifts rows between startRow and endRow n number of rows.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#shiftRows(int, int, int, boolean, boolean)">shiftRows</a></strong>(int&nbsp;startRow,
         int&nbsp;endRow,
         int&nbsp;n,
         boolean&nbsp;copyRowHeight,
         boolean&nbsp;resetOriginalRowHeight)</code>
<div class="block">Shifts rows between startRow and endRow n number of rows.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#showInPane(int, int)">showInPane</a></strong>(int&nbsp;toprow,
          int&nbsp;leftcol)</code>
<div class="block">Location of the top left visible cell Location of the top left visible cell in the bottom right
 pane (when in Left-to-Right mode).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#showInPane(short, short)">showInPane</a></strong>(short&nbsp;toprow,
          short&nbsp;leftcol)</code>
<div class="block"><strong>Deprecated.</strong>&nbsp;
<div class="block"><i>Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#showInPane(int, int)"><code>showInPane(int, int)</code></a> as there can be more than 32767 rows.</i></div>
</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#ungroupColumn(int, int)">ungroupColumn</a></strong>(int&nbsp;fromColumn,
             int&nbsp;toColumn)</code>
<div class="block">Ungroup a range of columns that were previously groupped</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#ungroupRow(int, int)">ungroupRow</a></strong>(int&nbsp;fromRow,
          int&nbsp;toRow)</code>
<div class="block">Ungroup a range of rows that were previously groupped</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#validateSheetPassword(java.lang.String)">validateSheetPassword</a></strong>(java.lang.String&nbsp;password)</code>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
  by the existing password attributes</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#write(java.io.OutputStream)">write</a></strong>(java.io.OutputStream&nbsp;out)</code>&nbsp;</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_org.apache.poi.POIXMLDocumentPart">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.poi.<a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></h3>
<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#addRelation(java.lang.String, org.apache.poi.POIXMLDocumentPart)">addRelation</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#createRelationship(org.apache.poi.POIXMLRelation, org.apache.poi.POIXMLFactory)">createRelationship</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#createRelationship(org.apache.poi.POIXMLRelation, org.apache.poi.POIXMLFactory, int)">createRelationship</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#createRelationship(org.apache.poi.POIXMLRelation, org.apache.poi.POIXMLFactory, int, boolean)">createRelationship</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getPackagePart()">getPackagePart</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getPackageRelationship()">getPackageRelationship</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getParent()">getParent</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getRelationById(java.lang.String)">getRelationById</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getRelationId(org.apache.poi.POIXMLDocumentPart)">getRelationId</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getRelations()">getRelations</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#getTargetPart(org.apache.poi.openxml4j.opc.PackageRelationship)">getTargetPart</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#onDocumentRemove()">onDocumentRemove</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#onSave(java.util.Set)">onSave</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#prepareForCommit()">prepareForCommit</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#read(org.apache.poi.POIXMLFactory, java.util.Map)">read</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#rebase(org.apache.poi.openxml4j.opc.OPCPackage)">rebase</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#removeRelation(org.apache.poi.POIXMLDocumentPart)">removeRelation</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#removeRelation(org.apache.poi.POIXMLDocumentPart, boolean)">removeRelation</a>, <a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#toString()">toString</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ FIELD DETAIL =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_detail">
<!--   -->
</a>
<h3>Field Detail</h3>
<a name="sheet">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>sheet</h4>
<pre>protected&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTSheet sheet</pre>
</li>
</ul>
<a name="worksheet">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>worksheet</h4>
<pre>protected&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet worksheet</pre>
</li>
</ul>
</li>
</ul>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_detail">
<!--   -->
</a>
<h3>Constructor Detail</h3>
<a name="XSSFSheet()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>XSSFSheet</h4>
<pre>protected&nbsp;XSSFSheet()</pre>
<div class="block">Creates new XSSFSheet   - called by XSSFWorkbook to create a sheet from scratch.</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html#createSheet()"><code>XSSFWorkbook.createSheet()</code></a></dd></dl>
</li>
</ul>
<a name="XSSFSheet(org.apache.poi.openxml4j.opc.PackagePart, org.apache.poi.openxml4j.opc.PackageRelationship)">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>XSSFSheet</h4>
<pre>protected&nbsp;XSSFSheet(<a href="../../../../../org/apache/poi/openxml4j/opc/PackagePart.html" title="class in org.apache.poi.openxml4j.opc">PackagePart</a>&nbsp;part,
         <a href="../../../../../org/apache/poi/openxml4j/opc/PackageRelationship.html" title="class in org.apache.poi.openxml4j.opc">PackageRelationship</a>&nbsp;rel)</pre>
<div class="block">Creates an XSSFSheet representing the given package part and relationship.
 Should only be called by XSSFWorkbook when reading in an exisiting file.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>part</code> - - The package part that holds xml data represenring this sheet.</dd><dd><code>rel</code> - - the relationship of the given package part in the underlying OPC package</dd></dl>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method_detail">
<!--   -->
</a>
<h3>Method Detail</h3>
<a name="getWorkbook()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getWorkbook</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFWorkbook.html" title="class in org.apache.poi.xssf.usermodel">XSSFWorkbook</a>&nbsp;getWorkbook()</pre>
<div class="block">Returns the parent XSSFWorkbook</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getWorkbook()">getWorkbook</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the parent XSSFWorkbook</dd></dl>
</li>
</ul>
<a name="onDocumentRead()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>onDocumentRead</h4>
<pre>protected&nbsp;void&nbsp;onDocumentRead()</pre>
<div class="block">Initialize worksheet data when reading in an exisiting file.</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#onDocumentRead()">onDocumentRead</a></code>&nbsp;in class&nbsp;<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></code></dd>
</dl>
</li>
</ul>
<a name="read(java.io.InputStream)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>read</h4>
<pre>protected&nbsp;void&nbsp;read(java.io.InputStream&nbsp;is)
             throws java.io.IOException</pre>
<dl><dt><span class="strong">Throws:</span></dt>
<dd><code>java.io.IOException</code></dd></dl>
</li>
</ul>
<a name="onDocumentCreate()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>onDocumentCreate</h4>
<pre>protected&nbsp;void&nbsp;onDocumentCreate()</pre>
<div class="block">Initialize worksheet data when creating a new sheet.</div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#onDocumentCreate()">onDocumentCreate</a></code>&nbsp;in class&nbsp;<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></code></dd>
</dl>
</li>
</ul>
<a name="getCTWorksheet()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCTWorksheet</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTWorksheet&nbsp;getCTWorksheet()</pre>
<div class="block">Provide access to the CTWorksheet bean holding this sheet's data</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the CTWorksheet bean holding this sheet's data</dd></dl>
</li>
</ul>
<a name="getColumnHelper()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnHelper</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/helpers/ColumnHelper.html" title="class in org.apache.poi.xssf.usermodel.helpers">ColumnHelper</a>&nbsp;getColumnHelper()</pre>
</li>
</ul>
<a name="getSheetName()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getSheetName</h4>
<pre>public&nbsp;java.lang.String&nbsp;getSheetName()</pre>
<div class="block">Returns the name of this sheet</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetName()">getSheetName</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the name of this sheet</dd></dl>
</li>
</ul>
<a name="addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>addMergedRegion</h4>
<pre>public&nbsp;int&nbsp;addMergedRegion(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;region)</pre>
<div class="block">Adds a merged region of cells (hence those cells form one).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addMergedRegion(org.apache.poi.ss.util.CellRangeAddress)">addMergedRegion</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>region</code> - (rowfrom/colfrom-rowto/colto) to merge</dd>
<dt><span class="strong">Returns:</span></dt><dd>index of this region</dd></dl>
</li>
</ul>
<a name="autoSizeColumn(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>autoSizeColumn</h4>
<pre>public&nbsp;void&nbsp;autoSizeColumn(int&nbsp;column)</pre>
<div class="block">Adjusts the column width to fit the contents.

 This process can be relatively slow on large sheets, so this should
  normally only be called once per column, at the end of your
  processing.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int)">autoSizeColumn</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column index</dd></dl>
</li>
</ul>
<a name="autoSizeColumn(int, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>autoSizeColumn</h4>
<pre>public&nbsp;void&nbsp;autoSizeColumn(int&nbsp;column,
                  boolean&nbsp;useMergedCells)</pre>
<div class="block">Adjusts the column width to fit the contents.
 <p>
 This process can be relatively slow on large sheets, so this should
  normally only be called once per column, at the end of your
  processing.
 </p>
 You can specify whether the content of merged cells should be considered or ignored.
  Default is to ignore merged cells.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#autoSizeColumn(int, boolean)">autoSizeColumn</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column index</dd><dd><code>useMergedCells</code> - whether to use the contents of merged cells when calculating the width of the column</dd></dl>
</li>
</ul>
<a name="createDrawingPatriarch()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createDrawingPatriarch</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDrawing.html" title="class in org.apache.poi.xssf.usermodel">XSSFDrawing</a>&nbsp;createDrawingPatriarch()</pre>
<div class="block">Create a new SpreadsheetML drawing. If this sheet already contains a drawing - return that.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createDrawingPatriarch()">createDrawingPatriarch</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>a SpreadsheetML drawing</dd></dl>
</li>
</ul>
<a name="getVMLDrawing(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getVMLDrawing</h4>
<pre>protected&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFVMLDrawing.html" title="class in org.apache.poi.xssf.usermodel">XSSFVMLDrawing</a>&nbsp;getVMLDrawing(boolean&nbsp;autoCreate)</pre>
<div class="block">Get VML drawing for this sheet (aka 'legacy' drawig)</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>autoCreate</code> - if true, then a new VML drawing part is created</dd>
<dt><span class="strong">Returns:</span></dt><dd>the VML drawing of <code>null</code> if the drawing was not found and autoCreate=false</dd></dl>
</li>
</ul>
<a name="getCTDrawing()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCTDrawing</h4>
<pre>protected&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDrawing&nbsp;getCTDrawing()</pre>
</li>
</ul>
<a name="getCTLegacyDrawing()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCTLegacyDrawing</h4>
<pre>protected&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTLegacyDrawing&nbsp;getCTLegacyDrawing()</pre>
</li>
</ul>
<a name="createFreezePane(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createFreezePane</h4>
<pre>public&nbsp;void&nbsp;createFreezePane(int&nbsp;colSplit,
                    int&nbsp;rowSplit)</pre>
<div class="block">Creates a split (freezepane). Any existing freezepane or split pane is overwritten.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int, int)">createFreezePane</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>colSplit</code> - Horizonatal position of split.</dd><dd><code>rowSplit</code> - Vertical position of split.</dd></dl>
</li>
</ul>
<a name="createFreezePane(int, int, int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createFreezePane</h4>
<pre>public&nbsp;void&nbsp;createFreezePane(int&nbsp;colSplit,
                    int&nbsp;rowSplit,
                    int&nbsp;leftmostColumn,
                    int&nbsp;topRow)</pre>
<div class="block">Creates a split (freezepane). Any existing freezepane or split pane is overwritten.

 <p>
     If both colSplit and rowSplit are zero then the existing freeze pane is removed
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createFreezePane(int, int, int, int)">createFreezePane</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>colSplit</code> - Horizonatal position of split.</dd><dd><code>rowSplit</code> - Vertical position of split.</dd><dd><code>leftmostColumn</code> - Left column visible in right pane.</dd><dd><code>topRow</code> - Top row visible in bottom pane</dd></dl>
</li>
</ul>
<a name="createComment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createComment</h4>
<pre>@Deprecated
public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>&nbsp;createComment()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>since Nov 2009 this method is not compatible with the common SS interfaces,
 use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDrawing.html#createCellComment(org.apache.poi.ss.usermodel.ClientAnchor)"><code>(org.apache.poi.ss.usermodel.ClientAnchor)</code></a> instead</i></div>
<div class="block">Creates a new comment for this sheet. You still
  need to assign it to a cell though</div>
</li>
</ul>
<a name="createRow(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createRow</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a>&nbsp;createRow(int&nbsp;rownum)</pre>
<div class="block">Create a new row within the sheet and return the high level representation</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createRow(int)">createRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>rownum</code> - row number</dd>
<dt><span class="strong">Returns:</span></dt><dd>High level <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel"><code>XSSFRow</code></a> object representing a row in the sheet</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#removeRow(org.apache.poi.ss.usermodel.Row)"><code>removeRow(org.apache.poi.ss.usermodel.Row)</code></a></dd></dl>
</li>
</ul>
<a name="createSplitPane(int, int, int, int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createSplitPane</h4>
<pre>public&nbsp;void&nbsp;createSplitPane(int&nbsp;xSplitPos,
                   int&nbsp;ySplitPos,
                   int&nbsp;leftmostColumn,
                   int&nbsp;topRow,
                   int&nbsp;activePane)</pre>
<div class="block">Creates a split pane. Any existing freezepane or split pane is overwritten.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#createSplitPane(int, int, int, int, int)">createSplitPane</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>xSplitPos</code> - Horizonatal position of split (in 1/20th of a point).</dd><dd><code>ySplitPos</code> - Vertical position of split (in 1/20th of a point).</dd><dd><code>topRow</code> - Top row visible in bottom pane</dd><dd><code>leftmostColumn</code> - Left column visible in right pane.</dd><dd><code>activePane</code> - Active pane.  One of: PANE_LOWER_RIGHT,
                      PANE_UPPER_RIGHT, PANE_LOWER_LEFT, PANE_UPPER_LEFT</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_LOWER_LEFT"><code>Sheet.PANE_LOWER_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_LOWER_RIGHT"><code>Sheet.PANE_LOWER_RIGHT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_UPPER_LEFT"><code>Sheet.PANE_UPPER_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#PANE_UPPER_RIGHT"><code>Sheet.PANE_UPPER_RIGHT</code></a></dd></dl>
</li>
</ul>
<a name="getCellComment(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCellComment</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>&nbsp;getCellComment(int&nbsp;row,
                         int&nbsp;column)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int, int)">Sheet</a></code></strong></div>
<div class="block">Returns cell comment for the specified row and column</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getCellComment(int, int)">getCellComment</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>cell comment or <code>null</code> if not found</dd></dl>
</li>
</ul>
<a name="getHyperlink(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHyperlink</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a>&nbsp;getHyperlink(int&nbsp;row,
                         int&nbsp;column)</pre>
</li>
</ul>
<a name="getColumnBreaks()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnBreaks</h4>
<pre>public&nbsp;int[]&nbsp;getColumnBreaks()</pre>
<div class="block">Vertical page break information used for print layout view, page layout view, drawing print breaks
 in normal view, and for printing the worksheet.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnBreaks()">getColumnBreaks</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>column indexes of all the vertical page breaks, never <code>null</code></dd></dl>
</li>
</ul>
<a name="getColumnWidth(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnWidth</h4>
<pre>public&nbsp;int&nbsp;getColumnWidth(int&nbsp;columnIndex)</pre>
<div class="block">Get the actual column width (in units of 1/256th of a character width )

 <p>
 Note, the returned  value is always gerater that <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getDefaultColumnWidth()"><code>getDefaultColumnWidth()</code></a> because the latter does not include margins.
 Actual column width measured as the number of characters of the maximum digit width of the
 numbers 0, 1, 2, ..., 9 as rendered in the normal style's font. There are 4 pixels of margin
 padding (two on each side), plus 1 pixel padding for the gridlines.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidth(int)">getColumnWidth</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnIndex</code> - - the column to set (0-based)</dd>
<dt><span class="strong">Returns:</span></dt><dd>width - the width in units of 1/256th of a character width</dd></dl>
</li>
</ul>
<a name="getColumnWidthInPixels(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnWidthInPixels</h4>
<pre>public&nbsp;float&nbsp;getColumnWidthInPixels(int&nbsp;columnIndex)</pre>
<div class="block">Get the actual column width in pixels
 
 <p>
 Please note, that this method works correctly only for workbooks
 with the default font size (Calibri 11pt for .xlsx).
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnWidthInPixels(int)">getColumnWidthInPixels</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnIndex</code> - - the column to set (0-based)</dd>
<dt><span class="strong">Returns:</span></dt><dd>width in pixels</dd></dl>
</li>
</ul>
<a name="getDefaultColumnWidth()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDefaultColumnWidth</h4>
<pre>public&nbsp;int&nbsp;getDefaultColumnWidth()</pre>
<div class="block">Get the default column width for the sheet (if the columns do not define their own width) in
 characters.
 <p>
 Note, this value is different from <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getColumnWidth(int)"><code>getColumnWidth(int)</code></a>. The latter is always greater and includes
 4 pixels of margin padding (two on each side), plus 1 pixel padding for the gridlines.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultColumnWidth()">getDefaultColumnWidth</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>column width, default value is 8</dd></dl>
</li>
</ul>
<a name="getDefaultRowHeight()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDefaultRowHeight</h4>
<pre>public&nbsp;short&nbsp;getDefaultRowHeight()</pre>
<div class="block">Get the default row height for the sheet (if the rows do not define their own height) in
 twips (1/20 of  a point)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeight()">getDefaultRowHeight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>default row height</dd></dl>
</li>
</ul>
<a name="getDefaultRowHeightInPoints()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDefaultRowHeightInPoints</h4>
<pre>public&nbsp;float&nbsp;getDefaultRowHeightInPoints()</pre>
<div class="block">Get the default row height for the sheet measued in point size (if the rows do not define their own height).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDefaultRowHeightInPoints()">getDefaultRowHeightInPoints</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>default row height in points</dd></dl>
</li>
</ul>
<a name="getColumnStyle(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnStyle</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;getColumnStyle(int&nbsp;column)</pre>
<div class="block">Returns the CellStyle that applies to the given
  (0 based) column, or null if no style has been
  set for that column</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getColumnStyle(int)">getColumnStyle</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="setRightToLeft(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRightToLeft</h4>
<pre>public&nbsp;void&nbsp;setRightToLeft(boolean&nbsp;value)</pre>
<div class="block">Sets whether the worksheet is displayed from right to left instead of from left to right.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRightToLeft(boolean)">setRightToLeft</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - true for right to left, false otherwise.</dd></dl>
</li>
</ul>
<a name="isRightToLeft()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isRightToLeft</h4>
<pre>public&nbsp;boolean&nbsp;isRightToLeft()</pre>
<div class="block">Whether the text is displayed in right-to-left mode in the window</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRightToLeft()">isRightToLeft</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>whether the text is displayed in right-to-left mode in the window</dd></dl>
</li>
</ul>
<a name="getDisplayGuts()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDisplayGuts</h4>
<pre>public&nbsp;boolean&nbsp;getDisplayGuts()</pre>
<div class="block">Get whether to display the guts or not,
 default value is true</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDisplayGuts()">getDisplayGuts</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>boolean - guts or no guts</dd></dl>
</li>
</ul>
<a name="setDisplayGuts(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDisplayGuts</h4>
<pre>public&nbsp;void&nbsp;setDisplayGuts(boolean&nbsp;value)</pre>
<div class="block">Set whether to display the guts or not</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGuts(boolean)">setDisplayGuts</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - - guts or no guts</dd></dl>
</li>
</ul>
<a name="isDisplayZeros()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDisplayZeros</h4>
<pre>public&nbsp;boolean&nbsp;isDisplayZeros()</pre>
<div class="block">Gets the flag indicating whether the window should show 0 (zero) in cells containing zero value.
 When false, cells with zero value appear blank instead of showing the number zero.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayZeros()">isDisplayZeros</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>whether all zero values on the worksheet are displayed</dd></dl>
</li>
</ul>
<a name="setDisplayZeros(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDisplayZeros</h4>
<pre>public&nbsp;void&nbsp;setDisplayZeros(boolean&nbsp;value)</pre>
<div class="block">Set whether the window should show 0 (zero) in cells containing zero value.
 When false, cells with zero value appear blank instead of showing the number zero.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayZeros(boolean)">setDisplayZeros</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - whether to display or hide all zero values on the worksheet</dd></dl>
</li>
</ul>
<a name="getFirstRowNum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFirstRowNum</h4>
<pre>public&nbsp;int&nbsp;getFirstRowNum()</pre>
<div class="block">Gets the first row on the sheet</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFirstRowNum()">getFirstRowNum</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the number of the first logical row on the sheet, zero based</dd></dl>
</li>
</ul>
<a name="getFitToPage()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFitToPage</h4>
<pre>public&nbsp;boolean&nbsp;getFitToPage()</pre>
<div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFitToPage()">getFitToPage</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code></dd></dl>
</li>
</ul>
<a name="getFooter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFooter</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a>&nbsp;getFooter()</pre>
<div class="block">Returns the default footer for the sheet,
  creating one as needed.
 You may also want to look at
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFirstFooter()"><code>getFirstFooter()</code></a>,
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getOddFooter()"><code>getOddFooter()</code></a> and
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getEvenFooter()"><code>getEvenFooter()</code></a></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getFooter()">getFooter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the document footer. Never <code>null</code></dd></dl>
</li>
</ul>
<a name="getHeader()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHeader</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a>&nbsp;getHeader()</pre>
<div class="block">Returns the default header for the sheet,
  creating one as needed.
 You may also want to look at
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getFirstHeader()"><code>getFirstHeader()</code></a>,
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getOddHeader()"><code>getOddHeader()</code></a> and
  <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#getEvenHeader()"><code>getEvenHeader()</code></a></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHeader()">getHeader</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the document header. Never <code>null</code></dd></dl>
</li>
</ul>
<a name="getOddFooter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getOddFooter</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a>&nbsp;getOddFooter()</pre>
<div class="block">Returns the odd footer. Used on all pages unless
  other footers also present, when used on only
  odd pages.</div>
</li>
</ul>
<a name="getEvenFooter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getEvenFooter</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a>&nbsp;getEvenFooter()</pre>
<div class="block">Returns the even footer. Not there by default, but
  when set, used on even pages.</div>
</li>
</ul>
<a name="getFirstFooter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFirstFooter</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Footer.html" title="interface in org.apache.poi.ss.usermodel">Footer</a>&nbsp;getFirstFooter()</pre>
<div class="block">Returns the first page footer. Not there by
  default, but when set, used on the first page.</div>
</li>
</ul>
<a name="getOddHeader()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getOddHeader</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a>&nbsp;getOddHeader()</pre>
<div class="block">Returns the odd header. Used on all pages unless
  other headers also present, when used on only
  odd pages.</div>
</li>
</ul>
<a name="getEvenHeader()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getEvenHeader</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a>&nbsp;getEvenHeader()</pre>
<div class="block">Returns the even header. Not there by default, but
  when set, used on even pages.</div>
</li>
</ul>
<a name="getFirstHeader()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFirstHeader</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/Header.html" title="interface in org.apache.poi.ss.usermodel">Header</a>&nbsp;getFirstHeader()</pre>
<div class="block">Returns the first page header. Not there by
  default, but when set, used on the first page.</div>
</li>
</ul>
<a name="getHorizontallyCenter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHorizontallyCenter</h4>
<pre>public&nbsp;boolean&nbsp;getHorizontallyCenter()</pre>
<div class="block">Determine whether printed output for this sheet will be horizontally centered.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getHorizontallyCenter()">getHorizontallyCenter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="getLastRowNum()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLastRowNum</h4>
<pre>public&nbsp;int&nbsp;getLastRowNum()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">Sheet</a></code></strong></div>
<div class="block">Gets the last row on the sheet</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLastRowNum()">getLastRowNum</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>last row contained n this sheet (0-based)</dd></dl>
</li>
</ul>
<a name="getLeftCol()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLeftCol</h4>
<pre>public&nbsp;short&nbsp;getLeftCol()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">Sheet</a></code></strong></div>
<div class="block">The left col in the visible view when the sheet is
 first viewed after opening it in a viewer</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getLeftCol()">getLeftCol</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>short indicating the rownum (0 based) of the top row</dd></dl>
</li>
</ul>
<a name="getMargin(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getMargin</h4>
<pre>public&nbsp;double&nbsp;getMargin(short&nbsp;margin)</pre>
<div class="block">Gets the size of the margin in inches.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMargin(short)">getMargin</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>margin</code> - which margin to get</dd>
<dt><span class="strong">Returns:</span></dt><dd>the size of the margin</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#LeftMargin"><code>Sheet.LeftMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#RightMargin"><code>Sheet.RightMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#TopMargin"><code>Sheet.TopMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#BottomMargin"><code>Sheet.BottomMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#HeaderMargin"><code>Sheet.HeaderMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#FooterMargin"><code>Sheet.FooterMargin</code></a></dd></dl>
</li>
</ul>
<a name="setMargin(short, double)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setMargin</h4>
<pre>public&nbsp;void&nbsp;setMargin(short&nbsp;margin,
             double&nbsp;size)</pre>
<div class="block">Sets the size of the margin in inches.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setMargin(short, double)">setMargin</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>margin</code> - which margin to get</dd><dd><code>size</code> - the size of the margin</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#LeftMargin"><code>Sheet.LeftMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#RightMargin"><code>Sheet.RightMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#TopMargin"><code>Sheet.TopMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#BottomMargin"><code>Sheet.BottomMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#HeaderMargin"><code>Sheet.HeaderMargin</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#FooterMargin"><code>Sheet.FooterMargin</code></a></dd></dl>
</li>
</ul>
<a name="getMergedRegion(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getMergedRegion</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;getMergedRegion(int&nbsp;index)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">Sheet</a></code></strong></div>
<div class="block">Returns the merged region at the specified index</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getMergedRegion(int)">getMergedRegion</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the merged region at the specified index</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalStateException</code> - if this worksheet does not contain merged regions</dd></dl>
</li>
</ul>
<a name="getNumMergedRegions()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getNumMergedRegions</h4>
<pre>public&nbsp;int&nbsp;getNumMergedRegions()</pre>
<div class="block">Returns the number of merged regions defined in this worksheet</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getNumMergedRegions()">getNumMergedRegions</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>number of merged regions in this worksheet</dd></dl>
</li>
</ul>
<a name="getNumHyperlinks()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getNumHyperlinks</h4>
<pre>public&nbsp;int&nbsp;getNumHyperlinks()</pre>
</li>
</ul>
<a name="getPaneInformation()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getPaneInformation</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/hssf/util/PaneInformation.html" title="class in org.apache.poi.hssf.util">PaneInformation</a>&nbsp;getPaneInformation()</pre>
<div class="block">Returns the information regarding the currently configured pane (split or freeze).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPaneInformation()">getPaneInformation</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>null if no pane configured, or the pane information.</dd></dl>
</li>
</ul>
<a name="getPhysicalNumberOfRows()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getPhysicalNumberOfRows</h4>
<pre>public&nbsp;int&nbsp;getPhysicalNumberOfRows()</pre>
<div class="block">Returns the number of physically defined rows (NOT the number of rows in the sheet)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPhysicalNumberOfRows()">getPhysicalNumberOfRows</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>the number of physically defined rows</dd></dl>
</li>
</ul>
<a name="getPrintSetup()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getPrintSetup</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPrintSetup.html" title="class in org.apache.poi.xssf.usermodel">XSSFPrintSetup</a>&nbsp;getPrintSetup()</pre>
<div class="block">Gets the print setup object.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getPrintSetup()">getPrintSetup</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>The user model for the print setup object.</dd></dl>
</li>
</ul>
<a name="getProtect()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getProtect</h4>
<pre>public&nbsp;boolean&nbsp;getProtect()</pre>
<div class="block">Answer whether protection is enabled or disabled</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getProtect()">getProtect</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>true => protection enabled; false => protection disabled</dd></dl>
</li>
</ul>
<a name="protectSheet(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>protectSheet</h4>
<pre>public&nbsp;void&nbsp;protectSheet(java.lang.String&nbsp;password)</pre>
<div class="block">Enables sheet protection and sets the password for the sheet.
 Also sets some attributes on the <code>CTSheetProtection</code> that correspond to
 the default values used by Excel</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#protectSheet(java.lang.String)">protectSheet</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>password</code> - to set for protection. Pass <code>null</code> to remove protection</dd></dl>
</li>
</ul>
<a name="setSheetPassword(java.lang.String, org.apache.poi.poifs.crypt.HashAlgorithm)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setSheetPassword</h4>
<pre>public&nbsp;void&nbsp;setSheetPassword(java.lang.String&nbsp;password,
                    <a href="../../../../../org/apache/poi/poifs/crypt/HashAlgorithm.html" title="enum in org.apache.poi.poifs.crypt">HashAlgorithm</a>&nbsp;hashAlgo)</pre>
<div class="block">Sets the sheet password.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>password</code> - if null, the password will be removed</dd><dd><code>hashAlgo</code> - if null, the password will be set as XOR password (Excel 2010 and earlier)
  otherwise the given algorithm is used for calculating the hash password (Excel 2013)</dd></dl>
</li>
</ul>
<a name="validateSheetPassword(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>validateSheetPassword</h4>
<pre>public&nbsp;boolean&nbsp;validateSheetPassword(java.lang.String&nbsp;password)</pre>
<div class="block">Validate the password against the stored hash, the hashing method will be determined
  by the existing password attributes</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>true, if the hashes match (... though original password may differ ...)</dd></dl>
</li>
</ul>
<a name="getRow(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRow</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFRow.html" title="class in org.apache.poi.xssf.usermodel">XSSFRow</a>&nbsp;getRow(int&nbsp;rownum)</pre>
<div class="block">Returns the logical row ( 0-based).  If you ask for a row that is not
 defined you get a null.  This is to say row 4 represents the fifth row on a sheet.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRow(int)">getRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>rownum</code> - row to get</dd>
<dt><span class="strong">Returns:</span></dt><dd><code>XSSFRow</code> representing the rownumber or <code>null</code> if its not defined on the sheet</dd></dl>
</li>
</ul>
<a name="getRowBreaks()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRowBreaks</h4>
<pre>public&nbsp;int[]&nbsp;getRowBreaks()</pre>
<div class="block">Horizontal page break information used for print layout view, page layout view, drawing print breaks in normal
  view, and for printing the worksheet.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowBreaks()">getRowBreaks</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>row indexes of all the horizontal page breaks, never <code>null</code></dd></dl>
</li>
</ul>
<a name="getRowSumsBelow()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRowSumsBelow</h4>
<pre>public&nbsp;boolean&nbsp;getRowSumsBelow()</pre>
<div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.

 <p>
 When true a summary row is inserted below the detailed data being summarized and a
 new outline level is established on that row.
 </p>
 <p>
 When false a summary row is inserted above the detailed data being summarized and a new outline level
 is established on that row.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsBelow()">getRowSumsBelow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if row summaries appear below detail in the outline</dd></dl>
</li>
</ul>
<a name="setRowSumsBelow(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRowSumsBelow</h4>
<pre>public&nbsp;void&nbsp;setRowSumsBelow(boolean&nbsp;value)</pre>
<div class="block">Flag indicating whether summary rows appear below detail in an outline, when applying an outline.

 <p>
 When true a summary row is inserted below the detailed data being summarized and a
 new outline level is established on that row.
 </p>
 <p>
 When false a summary row is inserted above the detailed data being summarized and a new outline level
 is established on that row.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsBelow(boolean)">setRowSumsBelow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - <code>true</code> if row summaries appear below detail in the outline</dd></dl>
</li>
</ul>
<a name="getRowSumsRight()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRowSumsRight</h4>
<pre>public&nbsp;boolean&nbsp;getRowSumsRight()</pre>
<div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.

 <p>
 When true a summary column is inserted to the right of the detailed data being summarized
 and a new outline level is established on that column.
 </p>
 <p>
 When false a summary column is inserted to the left of the detailed data being
 summarized and a new outline level is established on that column.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRowSumsRight()">getRowSumsRight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if col summaries appear right of the detail in the outline</dd></dl>
</li>
</ul>
<a name="setRowSumsRight(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRowSumsRight</h4>
<pre>public&nbsp;void&nbsp;setRowSumsRight(boolean&nbsp;value)</pre>
<div class="block">Flag indicating whether summary columns appear to the right of detail in an outline, when applying an outline.

 <p>
 When true a summary column is inserted to the right of the detailed data being summarized
 and a new outline level is established on that column.
 </p>
 <p>
 When false a summary column is inserted to the left of the detailed data being
 summarized and a new outline level is established on that column.
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowSumsRight(boolean)">setRowSumsRight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - <code>true</code> if col summaries appear right of the detail in the outline</dd></dl>
</li>
</ul>
<a name="getScenarioProtect()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getScenarioProtect</h4>
<pre>public&nbsp;boolean&nbsp;getScenarioProtect()</pre>
<div class="block">A flag indicating whether scenarios are locked when the sheet is protected.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getScenarioProtect()">getScenarioProtect</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>true => protection enabled; false => protection disabled</dd></dl>
</li>
</ul>
<a name="getTopRow()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getTopRow</h4>
<pre>public&nbsp;short&nbsp;getTopRow()</pre>
<div class="block">The top row in the visible view when the sheet is
 first viewed after opening it in a viewer</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getTopRow()">getTopRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>integer indicating the rownum (0 based) of the top row</dd></dl>
</li>
</ul>
<a name="getVerticallyCenter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getVerticallyCenter</h4>
<pre>public&nbsp;boolean&nbsp;getVerticallyCenter()</pre>
<div class="block">Determine whether printed output for this sheet will be vertically centered.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getVerticallyCenter()">getVerticallyCenter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>whether printed output for this sheet will be vertically centered.</dd></dl>
</li>
</ul>
<a name="groupColumn(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>groupColumn</h4>
<pre>public&nbsp;void&nbsp;groupColumn(int&nbsp;fromColumn,
               int&nbsp;toColumn)</pre>
<div class="block">Group between (0 based) columns</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupColumn(int, int)">groupColumn</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fromColumn</code> - beginning of the column range.</dd><dd><code>toColumn</code> - end of the column range.</dd></dl>
</li>
</ul>
<a name="groupRow(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>groupRow</h4>
<pre>public&nbsp;void&nbsp;groupRow(int&nbsp;fromRow,
            int&nbsp;toRow)</pre>
<div class="block">Tie a range of cell together so that they can be collapsed or expanded</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#groupRow(int, int)">groupRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fromRow</code> - start row (0-based)</dd><dd><code>toRow</code> - end row (0-based)</dd></dl>
</li>
</ul>
<a name="isColumnBroken(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isColumnBroken</h4>
<pre>public&nbsp;boolean&nbsp;isColumnBroken(int&nbsp;column)</pre>
<div class="block">Determines if there is a page break at the indicated column</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnBroken(int)">isColumnBroken</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - FIXME: Document this!</dd>
<dt><span class="strong">Returns:</span></dt><dd>FIXME: Document this!</dd></dl>
</li>
</ul>
<a name="isColumnHidden(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isColumnHidden</h4>
<pre>public&nbsp;boolean&nbsp;isColumnHidden(int&nbsp;columnIndex)</pre>
<div class="block">Get the hidden state for a given column.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isColumnHidden(int)">isColumnHidden</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnIndex</code> - - the column to set (0-based)</dd>
<dt><span class="strong">Returns:</span></dt><dd>hidden - <code>false</code> if the column is visible</dd></dl>
</li>
</ul>
<a name="isDisplayFormulas()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDisplayFormulas</h4>
<pre>public&nbsp;boolean&nbsp;isDisplayFormulas()</pre>
<div class="block">Gets the flag indicating whether this sheet should display formulas.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayFormulas()">isDisplayFormulas</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if this sheet should display formulas.</dd></dl>
</li>
</ul>
<a name="isDisplayGridlines()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDisplayGridlines</h4>
<pre>public&nbsp;boolean&nbsp;isDisplayGridlines()</pre>
<div class="block">Gets the flag indicating whether this sheet displays the lines
 between rows and columns to make editing and reading easier.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayGridlines()">isDisplayGridlines</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if this sheet displays gridlines.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#isPrintGridlines()"><code>to check if printing of gridlines is turned on or off</code></a></dd></dl>
</li>
</ul>
<a name="setDisplayGridlines(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDisplayGridlines</h4>
<pre>public&nbsp;void&nbsp;setDisplayGridlines(boolean&nbsp;show)</pre>
<div class="block">Sets the flag indicating whether this sheet should display the lines
 between rows and columns to make editing and reading easier.
 To turn printing of gridlines use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setPrintGridlines(boolean)"><code>setPrintGridlines(boolean)</code></a></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayGridlines(boolean)">setDisplayGridlines</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>show</code> - <code>true</code> if this sheet should display gridlines.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setPrintGridlines(boolean)"><code>setPrintGridlines(boolean)</code></a></dd></dl>
</li>
</ul>
<a name="isDisplayRowColHeadings()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDisplayRowColHeadings</h4>
<pre>public&nbsp;boolean&nbsp;isDisplayRowColHeadings()</pre>
<div class="block">Gets the flag indicating whether this sheet should display row and column headings.
 <p>
 Row heading are the row numbers to the side of the sheet
 </p>
 <p>
 Column heading are the letters or numbers that appear above the columns of the sheet
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isDisplayRowColHeadings()">isDisplayRowColHeadings</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if this sheet should display row and column headings.</dd></dl>
</li>
</ul>
<a name="setDisplayRowColHeadings(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDisplayRowColHeadings</h4>
<pre>public&nbsp;void&nbsp;setDisplayRowColHeadings(boolean&nbsp;show)</pre>
<div class="block">Sets the flag indicating whether this sheet should display row and column headings.
 <p>
 Row heading are the row numbers to the side of the sheet
 </p>
 <p>
 Column heading are the letters or numbers that appear above the columns of the sheet
 </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayRowColHeadings(boolean)">setDisplayRowColHeadings</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>show</code> - <code>true</code> if this sheet should display row and column headings.</dd></dl>
</li>
</ul>
<a name="isPrintGridlines()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isPrintGridlines</h4>
<pre>public&nbsp;boolean&nbsp;isPrintGridlines()</pre>
<div class="block">Returns whether gridlines are printed.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()">isPrintGridlines</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>whether gridlines are printed</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isPrintGridlines()"><code>to check if printing of gridlines is turned on or off</code></a></dd></dl>
</li>
</ul>
<a name="setPrintGridlines(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setPrintGridlines</h4>
<pre>public&nbsp;void&nbsp;setPrintGridlines(boolean&nbsp;value)</pre>
<div class="block">Turns on or off the printing of gridlines.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setPrintGridlines(boolean)">setPrintGridlines</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - boolean to turn on or off the printing of gridlines</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setPrintGridlines(boolean)"><code>Sheet.setPrintGridlines(boolean)</code></a></dd></dl>
</li>
</ul>
<a name="isRowBroken(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isRowBroken</h4>
<pre>public&nbsp;boolean&nbsp;isRowBroken(int&nbsp;row)</pre>
<div class="block">Tests if there is a page break at the indicated row</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isRowBroken(int)">isRowBroken</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - index of the row to test</dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if there is a page break at the indicated row</dd></dl>
</li>
</ul>
<a name="setRowBreak(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRowBreak</h4>
<pre>public&nbsp;void&nbsp;setRowBreak(int&nbsp;row)</pre>
<div class="block">Sets a page break at the indicated row
 Breaks occur above the specified row and left of the specified column inclusive.

 For example, <code>sheet.setColumnBreak(2);</code> breaks the sheet into two parts
 with columns A,B,C in the first and D,E,... in the second. Simuilar, <code>sheet.setRowBreak(2);</code>
 breaks the sheet into two parts with first three rows (rownum=1...3) in the first part
 and rows starting with rownum=4 in the second.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowBreak(int)">setRowBreak</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - the row to break, inclusive</dd></dl>
</li>
</ul>
<a name="removeColumnBreak(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeColumnBreak</h4>
<pre>public&nbsp;void&nbsp;removeColumnBreak(int&nbsp;column)</pre>
<div class="block">Removes a page break at the indicated column</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeColumnBreak(int)">removeColumnBreak</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="removeMergedRegion(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeMergedRegion</h4>
<pre>public&nbsp;void&nbsp;removeMergedRegion(int&nbsp;index)</pre>
<div class="block">Removes a merged region of cells (hence letting them free)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeMergedRegion(int)">removeMergedRegion</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>index</code> - of the region to unmerge</dd></dl>
</li>
</ul>
<a name="removeMergedRegions(java.util.Set)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeMergedRegions</h4>
<pre>public&nbsp;void&nbsp;removeMergedRegions(java.util.Set&lt;java.lang.Integer&gt;&nbsp;indices)</pre>
<div class="block">Removes a number of merged regions of cells (hence letting them free)

 This method can be used to bulk-remove merged regions in a way
 much faster than calling removeMergedRegion() for every single
 merged region.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>indices</code> - A set of the regions to unmerge</dd></dl>
</li>
</ul>
<a name="removeRow(org.apache.poi.ss.usermodel.Row)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeRow</h4>
<pre>public&nbsp;void&nbsp;removeRow(<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&nbsp;row)</pre>
<div class="block">Remove a row from this sheet.  All cells contained in the row are removed as well</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRow(org.apache.poi.ss.usermodel.Row)">removeRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - the row to remove.</dd></dl>
</li>
</ul>
<a name="removeRowBreak(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeRowBreak</h4>
<pre>public&nbsp;void&nbsp;removeRowBreak(int&nbsp;row)</pre>
<div class="block">Removes the page break at the indicated row</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeRowBreak(int)">removeRowBreak</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="setForceFormulaRecalculation(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setForceFormulaRecalculation</h4>
<pre>public&nbsp;void&nbsp;setForceFormulaRecalculation(boolean&nbsp;value)</pre>
<div class="block">Control if Excel should be asked to recalculate all formulas on this sheet
 when the workbook is opened.

  <p>
  Calculating the formula values with <a href="../../../../../org/apache/poi/ss/usermodel/FormulaEvaluator.html" title="interface in org.apache.poi.ss.usermodel"><code>FormulaEvaluator</code></a> is the
  recommended solution, but this may be used for certain cases where
  evaluation in POI is not possible.
  </p>

  <p>
  It is recommended to force recalcuation of formulas on workbook level using
  <a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#setForceFormulaRecalculation(boolean)"><code>Workbook.setForceFormulaRecalculation(boolean)</code></a>
  to ensure that all cross-worksheet formuals and external dependencies are updated.
  </p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setForceFormulaRecalculation(boolean)">setForceFormulaRecalculation</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - true if the application will perform a full recalculation of
 this worksheet values when the workbook is opened</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#setForceFormulaRecalculation(boolean)"><code>Workbook.setForceFormulaRecalculation(boolean)</code></a></dd></dl>
</li>
</ul>
<a name="getForceFormulaRecalculation()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getForceFormulaRecalculation</h4>
<pre>public&nbsp;boolean&nbsp;getForceFormulaRecalculation()</pre>
<div class="block">Whether Excel will be asked to recalculate all formulas when the
  workbook is opened.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getForceFormulaRecalculation()">getForceFormulaRecalculation</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="rowIterator()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>rowIterator</h4>
<pre>public&nbsp;java.util.Iterator&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;&nbsp;rowIterator()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">Sheet</a></code></strong></div>
<div class="block">Returns an iterator of the physical rows</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#rowIterator()">rowIterator</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>an iterator of the PHYSICAL rows.  Meaning the 3rd element may not
 be the third row if say for instance the second row is undefined.
 Call getRowNum() on each row if you care which one it is.</dd></dl>
</li>
</ul>
<a name="iterator()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>iterator</h4>
<pre>public&nbsp;java.util.Iterator&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;&nbsp;iterator()</pre>
<div class="block">Alias for <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#rowIterator()"><code>rowIterator()</code></a> to
  allow foreach loops</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code>iterator</code>&nbsp;in interface&nbsp;<code>java.lang.Iterable&lt;<a href="../../../../../org/apache/poi/ss/usermodel/Row.html" title="interface in org.apache.poi.ss.usermodel">Row</a>&gt;</code></dd>
</dl>
</li>
</ul>
<a name="getAutobreaks()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getAutobreaks</h4>
<pre>public&nbsp;boolean&nbsp;getAutobreaks()</pre>
<div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getAutobreaks()">getAutobreaks</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if the sheet displays Automatic Page Breaks.</dd></dl>
</li>
</ul>
<a name="setAutobreaks(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAutobreaks</h4>
<pre>public&nbsp;void&nbsp;setAutobreaks(boolean&nbsp;value)</pre>
<div class="block">Flag indicating whether the sheet displays Automatic Page Breaks.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutobreaks(boolean)">setAutobreaks</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - <code>true</code> if the sheet displays Automatic Page Breaks.</dd></dl>
</li>
</ul>
<a name="setColumnBreak(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setColumnBreak</h4>
<pre>public&nbsp;void&nbsp;setColumnBreak(int&nbsp;column)</pre>
<div class="block">Sets a page break at the indicated column.
 Breaks occur above the specified row and left of the specified column inclusive.

 For example, <code>sheet.setColumnBreak(2);</code> breaks the sheet into two parts
 with columns A,B,C in the first and D,E,... in the second. Simuilar, <code>sheet.setRowBreak(2);</code>
 breaks the sheet into two parts with first three rows (rownum=1...3) in the first part
 and rows starting with rownum=4 in the second.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnBreak(int)">setColumnBreak</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column to break, inclusive</dd></dl>
</li>
</ul>
<a name="setColumnGroupCollapsed(int, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setColumnGroupCollapsed</h4>
<pre>public&nbsp;void&nbsp;setColumnGroupCollapsed(int&nbsp;columnNumber,
                           boolean&nbsp;collapsed)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int, boolean)">Sheet</a></code></strong></div>
<div class="block">Expands or collapses a column group.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnGroupCollapsed(int, boolean)">setColumnGroupCollapsed</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnNumber</code> - One of the columns in the group.</dd><dd><code>collapsed</code> - true = collapse group, false = expand group.</dd></dl>
</li>
</ul>
<a name="setColumnHidden(int, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setColumnHidden</h4>
<pre>public&nbsp;void&nbsp;setColumnHidden(int&nbsp;columnIndex,
                   boolean&nbsp;hidden)</pre>
<div class="block">Get the visibility state for a given column.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnHidden(int, boolean)">setColumnHidden</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnIndex</code> - - the column to get (0-based)</dd><dd><code>hidden</code> - - the visiblity state of the column</dd></dl>
</li>
</ul>
<a name="setColumnWidth(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setColumnWidth</h4>
<pre>public&nbsp;void&nbsp;setColumnWidth(int&nbsp;columnIndex,
                  int&nbsp;width)</pre>
<div class="block">Set the width (in units of 1/256th of a character width)

 <p>
 The maximum column width for an individual cell is 255 characters.
 This value represents the number of characters that can be displayed
 in a cell that is formatted with the standard font (first font in the workbook).
 </p>

 <p>
 Character width is defined as the maximum digit width
 of the numbers <code>0, 1, 2, ... 9</code> as rendered
 using the default font (first font in the workbook).
 <br/>
 Unless you are using a very special font, the default character is '0' (zero),
 this is true for Arial (default font font in HSSF) and Calibri (default font in XSSF)
 </p>

 <p>
 Please note, that the width set by this method includes 4 pixels of margin padding (two on each side),
 plus 1 pixel padding for the gridlines (Section 3.3.1.12 of the OOXML spec).
 This results is a slightly less value of visible characters than passed to this method (approx. 1/2 of a character).
 </p>
 <p>
 To compute the actual number of visible characters,
  Excel uses the following formula (Section 3.3.1.12 of the OOXML spec):
 </p>
 <code>
     width = Truncate([{Number of Visible Characters} *
      {Maximum Digit Width} + {5 pixel padding}]/{Maximum Digit Width}*256)/256
 </code>
 <p>Using the Calibri font as an example, the maximum digit width of 11 point font size is 7 pixels (at 96 dpi).
  If you set a column width to be eight characters wide, e.g. <code>setColumnWidth(columnIndex, 8*256)</code>,
  then the actual value of visible characters (the value shown in Excel) is derived from the following equation:
  <code>
            Truncate([numChars*7+5]/7*256)/256 = 8;
  </code>

  which gives <code>7.29</code>.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setColumnWidth(int, int)">setColumnWidth</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnIndex</code> - - the column to set (0-based)</dd><dd><code>width</code> - - the width in units of 1/256th of a character width</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if width > 255*256 (the maximum column width in Excel is 255 characters)</dd></dl>
</li>
</ul>
<a name="setDefaultColumnStyle(int, org.apache.poi.ss.usermodel.CellStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDefaultColumnStyle</h4>
<pre>public&nbsp;void&nbsp;setDefaultColumnStyle(int&nbsp;column,
                         <a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;style)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int, org.apache.poi.ss.usermodel.CellStyle)">Sheet</a></code></strong></div>
<div class="block">Sets the default column style for a given column.  POI will only apply this style to new cells added to the sheet.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnStyle(int, org.apache.poi.ss.usermodel.CellStyle)">setDefaultColumnStyle</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>column</code> - the column index</dd><dd><code>style</code> - the style to set</dd></dl>
</li>
</ul>
<a name="setDefaultColumnWidth(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDefaultColumnWidth</h4>
<pre>public&nbsp;void&nbsp;setDefaultColumnWidth(int&nbsp;width)</pre>
<div class="block">Specifies the number of characters of the maximum digit width of the normal style's font.
 This value does not include margin padding or extra padding for gridlines. It is only the
 number of characters.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultColumnWidth(int)">setDefaultColumnWidth</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>width</code> - the number of characters. Default value is <code>8</code>.</dd></dl>
</li>
</ul>
<a name="setDefaultRowHeight(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDefaultRowHeight</h4>
<pre>public&nbsp;void&nbsp;setDefaultRowHeight(short&nbsp;height)</pre>
<div class="block">Set the default row height for the sheet (if the rows do not define their own height) in
 twips (1/20 of  a point)</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeight(short)">setDefaultRowHeight</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>height</code> - default row height in  twips (1/20 of  a point)</dd></dl>
</li>
</ul>
<a name="setDefaultRowHeightInPoints(float)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDefaultRowHeightInPoints</h4>
<pre>public&nbsp;void&nbsp;setDefaultRowHeightInPoints(float&nbsp;height)</pre>
<div class="block">Sets default row height measured in point size.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDefaultRowHeightInPoints(float)">setDefaultRowHeightInPoints</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>height</code> - default row height measured in point size.</dd></dl>
</li>
</ul>
<a name="setDisplayFormulas(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDisplayFormulas</h4>
<pre>public&nbsp;void&nbsp;setDisplayFormulas(boolean&nbsp;show)</pre>
<div class="block">Sets the flag indicating whether this sheet should display formulas.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setDisplayFormulas(boolean)">setDisplayFormulas</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>show</code> - <code>true</code> if this sheet should display formulas.</dd></dl>
</li>
</ul>
<a name="setFitToPage(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFitToPage</h4>
<pre>public&nbsp;void&nbsp;setFitToPage(boolean&nbsp;b)</pre>
<div class="block">Flag indicating whether the Fit to Page print option is enabled.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setFitToPage(boolean)">setFitToPage</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>b</code> - <code>true</code> if the Fit to Page print option is enabled.</dd></dl>
</li>
</ul>
<a name="setHorizontallyCenter(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setHorizontallyCenter</h4>
<pre>public&nbsp;void&nbsp;setHorizontallyCenter(boolean&nbsp;value)</pre>
<div class="block">Center on page horizontally when printing.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setHorizontallyCenter(boolean)">setHorizontallyCenter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - whether to center on page horizontally when printing.</dd></dl>
</li>
</ul>
<a name="setVerticallyCenter(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setVerticallyCenter</h4>
<pre>public&nbsp;void&nbsp;setVerticallyCenter(boolean&nbsp;value)</pre>
<div class="block">Whether the output is vertically centered on the page.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setVerticallyCenter(boolean)">setVerticallyCenter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - true to vertically center, false otherwise.</dd></dl>
</li>
</ul>
<a name="setRowGroupCollapsed(int, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRowGroupCollapsed</h4>
<pre>public&nbsp;void&nbsp;setRowGroupCollapsed(int&nbsp;rowIndex,
                        boolean&nbsp;collapse)</pre>
<div class="block">group the row It is possible for collapsed to be false and yet still have
 the rows in question hidden. This can be achieved by having a lower
 outline level collapsed, thus hiding all the child rows. Note that in
 this case, if the lowest level were expanded, the middle level would
 remain collapsed.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRowGroupCollapsed(int, boolean)">setRowGroupCollapsed</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>rowIndex</code> - -
                the row involved, 0 based</dd><dd><code>collapse</code> - -
                boolean value for collapse</dd></dl>
</li>
</ul>
<a name="findEndOfRowOutlineGroup(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>findEndOfRowOutlineGroup</h4>
<pre>public&nbsp;int&nbsp;findEndOfRowOutlineGroup(int&nbsp;row)</pre>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - the zero based row index to find from</dd></dl>
</li>
</ul>
<a name="setZoom(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setZoom</h4>
<pre>public&nbsp;void&nbsp;setZoom(int&nbsp;numerator,
           int&nbsp;denominator)</pre>
<div class="block">Sets the zoom magnication for the sheet.  The zoom is expressed as a
 fraction.  For example to express a zoom of 75% use 3 for the numerator
 and 4 for the denominator.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setZoom(int, int)">setZoom</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>numerator</code> - The numerator for the zoom magnification.</dd><dd><code>denominator</code> - The denominator for the zoom magnification.</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#setZoom(int)"><code>setZoom(int)</code></a></dd></dl>
</li>
</ul>
<a name="setZoom(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setZoom</h4>
<pre>public&nbsp;void&nbsp;setZoom(int&nbsp;scale)</pre>
<div class="block">Window zoom magnification for current view representing percent values.
 Valid values range from 10 to 400. Horizontal & Vertical scale together.

 For example:
 <pre>
 10 - 10%
 20 - 20%
 ...
 100 - 100%
 ...
 400 - 400%
 </pre>

 Current view can be Normal, Page Layout, or Page Break Preview.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>scale</code> - window zoom magnification</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if scale is invalid</dd></dl>
</li>
</ul>
<a name="shiftRows(int, int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>shiftRows</h4>
<pre>public&nbsp;void&nbsp;shiftRows(int&nbsp;startRow,
             int&nbsp;endRow,
             int&nbsp;n)</pre>
<div class="block">Shifts rows between startRow and endRow n number of rows.
 If you use a negative number, it will shift rows up.
 Code ensures that rows don't wrap around.

 Calls shiftRows(startRow, endRow, n, false, false);

 <p>
 Additionally shifts merged regions that are completely defined in these
 rows (ie. merged 2 cells on a row to be shifted).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int, int, int)">shiftRows</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>startRow</code> - the row to start shifting</dd><dd><code>endRow</code> - the row to end shifting</dd><dd><code>n</code> - the number of rows to shift</dd></dl>
</li>
</ul>
<a name="shiftRows(int, int, int, boolean, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>shiftRows</h4>
<pre>public&nbsp;void&nbsp;shiftRows(int&nbsp;startRow,
             int&nbsp;endRow,
             int&nbsp;n,
             boolean&nbsp;copyRowHeight,
             boolean&nbsp;resetOriginalRowHeight)</pre>
<div class="block">Shifts rows between startRow and endRow n number of rows.
 If you use a negative number, it will shift rows up.
 Code ensures that rows don't wrap around

 <p>
 Additionally shifts merged regions that are completely defined in these
 rows (ie. merged 2 cells on a row to be shifted).
 <p></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#shiftRows(int, int, int, boolean, boolean)">shiftRows</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>startRow</code> - the row to start shifting</dd><dd><code>endRow</code> - the row to end shifting</dd><dd><code>n</code> - the number of rows to shift</dd><dd><code>copyRowHeight</code> - whether to copy the row height during the shift</dd><dd><code>resetOriginalRowHeight</code> - whether to set the original row's height to the default</dd></dl>
</li>
</ul>
<a name="showInPane(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>showInPane</h4>
<pre>public&nbsp;void&nbsp;showInPane(int&nbsp;toprow,
              int&nbsp;leftcol)</pre>
<div class="block">Location of the top left visible cell Location of the top left visible cell in the bottom right
 pane (when in Left-to-Right mode).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#showInPane(int, int)">showInPane</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>toprow</code> - the top row to show in desktop window pane</dd><dd><code>leftcol</code> - the left column to show in desktop window pane</dd></dl>
</li>
</ul>
<a name="showInPane(short, short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>showInPane</h4>
<pre>@Deprecated
public&nbsp;void&nbsp;showInPane(short&nbsp;toprow,
                         short&nbsp;leftcol)</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>Use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#showInPane(int, int)"><code>showInPane(int, int)</code></a> as there can be more than 32767 rows.</i></div>
<div class="block">Location of the top left visible cell Location of the top left visible cell in the bottom right
 pane (when in Left-to-Right mode).</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#showInPane(short, short)">showInPane</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>toprow</code> - the top row to show in desktop window pane</dd><dd><code>leftcol</code> - the left column to show in desktop window pane</dd></dl>
</li>
</ul>
<a name="ungroupColumn(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ungroupColumn</h4>
<pre>public&nbsp;void&nbsp;ungroupColumn(int&nbsp;fromColumn,
                 int&nbsp;toColumn)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupColumn(int, int)">Sheet</a></code></strong></div>
<div class="block">Ungroup a range of columns that were previously groupped</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupColumn(int, int)">ungroupColumn</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fromColumn</code> - start column (0-based)</dd><dd><code>toColumn</code> - end column (0-based)</dd></dl>
</li>
</ul>
<a name="ungroupRow(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ungroupRow</h4>
<pre>public&nbsp;void&nbsp;ungroupRow(int&nbsp;fromRow,
              int&nbsp;toRow)</pre>
<div class="block">Ungroup a range of rows that were previously groupped</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#ungroupRow(int, int)">ungroupRow</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>fromRow</code> - start row (0-based)</dd><dd><code>toRow</code> - end row (0-based)</dd></dl>
</li>
</ul>
<a name="isSelected()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isSelected</h4>
<pre>public&nbsp;boolean&nbsp;isSelected()</pre>
<div class="block">Returns a flag indicating whether this sheet is selected.
 <p>
 When only 1 sheet is selected and active, this value should be in synch with the activeTab value.
 In case of a conflict, the Start Part setting wins and sets the active sheet tab.
 </p>
 Note: multiple sheets can be selected, but only one sheet can be active at one time.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#isSelected()">isSelected</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd><code>true</code> if this sheet is selected</dd></dl>
</li>
</ul>
<a name="setSelected(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setSelected</h4>
<pre>public&nbsp;void&nbsp;setSelected(boolean&nbsp;value)</pre>
<div class="block">Sets a flag indicating whether this sheet is selected.

 <p>
 When only 1 sheet is selected and active, this value should be in synch with the activeTab value.
 In case of a conflict, the Start Part setting wins and sets the active sheet tab.
 </p>
 Note: multiple sheets can be selected, but only one sheet can be active at one time.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setSelected(boolean)">setSelected</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - <code>true</code> if this sheet is selected</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#setActiveSheet(int)"><code>Workbook.setActiveSheet(int)</code></a></dd></dl>
</li>
</ul>
<a name="setCellComment(java.lang.String, org.apache.poi.xssf.usermodel.XSSFComment)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setCellComment</h4>
<pre>@Deprecated
public static&nbsp;void&nbsp;setCellComment(java.lang.String&nbsp;cellRef,
                             <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFComment.html" title="class in org.apache.poi.xssf.usermodel">XSSFComment</a>&nbsp;comment)</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>since Nov 2009 use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html#setCellComment(org.apache.poi.ss.usermodel.Comment)"><code>XSSFCell.setCellComment(org.apache.poi.ss.usermodel.Comment)</code></a> instead</i></div>
<div class="block">Assign a cell comment to a cell region in this worksheet</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cellRef</code> - cell region</dd><dd><code>comment</code> - the comment to assign</dd></dl>
</li>
</ul>
<a name="addHyperlink(org.apache.poi.xssf.usermodel.XSSFHyperlink)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>addHyperlink</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;void&nbsp;addHyperlink(<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFHyperlink.html" title="class in org.apache.poi.xssf.usermodel">XSSFHyperlink</a>&nbsp;hyperlink)</pre>
<div class="block">Register a hyperlink in the collection of hyperlinks on this sheet</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>hyperlink</code> - the link to add</dd></dl>
</li>
</ul>
<a name="removeHyperlink(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeHyperlink</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;void&nbsp;removeHyperlink(int&nbsp;row,
                            int&nbsp;column)</pre>
<div class="block">Removes a hyperlink in the collection of hyperlinks on this sheet</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - row index</dd><dd><code>column</code> - column index</dd></dl>
</li>
</ul>
<a name="getActiveCell()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getActiveCell</h4>
<pre>public&nbsp;java.lang.String&nbsp;getActiveCell()</pre>
<div class="block">Return location of the active cell, e.g. <code>A1</code>.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the location of the active cell.</dd></dl>
</li>
</ul>
<a name="setActiveCell(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setActiveCell</h4>
<pre>public&nbsp;void&nbsp;setActiveCell(java.lang.String&nbsp;cellRef)</pre>
<div class="block">Sets location of the active cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>cellRef</code> - the location of the active cell, e.g. <code>A1</code>..</dd></dl>
</li>
</ul>
<a name="hasComments()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>hasComments</h4>
<pre>public&nbsp;boolean&nbsp;hasComments()</pre>
<div class="block">Does this sheet have any comments on it? We need to know,
  so we can decide about writing it to disk or not</div>
</li>
</ul>
<a name="getNumberOfComments()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getNumberOfComments</h4>
<pre>protected&nbsp;int&nbsp;getNumberOfComments()</pre>
</li>
</ul>
<a name="getCommentsTable(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getCommentsTable</h4>
<pre>protected&nbsp;<a href="../../../../../org/apache/poi/xssf/model/CommentsTable.html" title="class in org.apache.poi.xssf.model">CommentsTable</a>&nbsp;getCommentsTable(boolean&nbsp;create)</pre>
<div class="block">Returns the sheet's comments object if there is one,
  or null if not</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>create</code> - create a new comments table if it does not exist</dd></dl>
</li>
</ul>
<a name="getSharedFormula(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getSharedFormula</h4>
<pre><a href="../../../../../org/apache/poi/util/Internal.html" title="annotation in org.apache.poi.util">@Internal</a>
public&nbsp;org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCellFormula&nbsp;getSharedFormula(int&nbsp;sid)</pre>
<div class="block">Return a master shared formula by index</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>sid</code> - shared group index</dd>
<dt><span class="strong">Returns:</span></dt><dd>a CTCellFormula bean holding shared formula or <code>null</code> if not found</dd></dl>
</li>
</ul>
<a name="commit()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>commit</h4>
<pre>protected&nbsp;void&nbsp;commit()
               throws java.io.IOException</pre>
<div class="block"><strong>Description copied from class:&nbsp;<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#commit()">POIXMLDocumentPart</a></code></strong></div>
<div class="block">Save the content in the underlying package part.
 Default implementation is empty meaning that the package part is left unmodified.

 Sub-classes should override and add logic to marshal the "model" into Ooxml4J.

 For example, the code saving a generic XML entry may look as follows:
 <pre><code>
 protected void commit() throws IOException {
   PackagePart part = getPackagePart();
   OutputStream out = part.getOutputStream();
   XmlObject bean = getXmlBean(); //the "model" which holds changes in memory
   bean.save(out, DEFAULT_XML_OPTIONS);
   out.close();
 }
  </code></pre></div>
<dl>
<dt><strong>Overrides:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html#commit()">commit</a></code>&nbsp;in class&nbsp;<code><a href="../../../../../org/apache/poi/POIXMLDocumentPart.html" title="class in org.apache.poi">POIXMLDocumentPart</a></code></dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.io.IOException</code></dd></dl>
</li>
</ul>
<a name="write(java.io.OutputStream)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>write</h4>
<pre>protected&nbsp;void&nbsp;write(java.io.OutputStream&nbsp;out)
              throws java.io.IOException</pre>
<dl><dt><span class="strong">Throws:</span></dt>
<dd><code>java.io.IOException</code></dd></dl>
</li>
</ul>
<a name="isAutoFilterLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isAutoFilterLocked</h4>
<pre>public&nbsp;boolean&nbsp;isAutoFilterLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Autofilters are locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isDeleteColumnsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDeleteColumnsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isDeleteColumnsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Deleting columns is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isDeleteRowsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isDeleteRowsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isDeleteRowsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Deleting rows is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isFormatCellsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isFormatCellsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isFormatCellsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Formatting cells is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isFormatColumnsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isFormatColumnsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isFormatColumnsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Formatting columns is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isFormatRowsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isFormatRowsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isFormatRowsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Formatting rows is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isInsertColumnsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isInsertColumnsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isInsertColumnsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Inserting columns is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isInsertHyperlinksLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isInsertHyperlinksLocked</h4>
<pre>public&nbsp;boolean&nbsp;isInsertHyperlinksLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Inserting hyperlinks is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isInsertRowsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isInsertRowsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isInsertRowsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Inserting rows is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isPivotTablesLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isPivotTablesLocked</h4>
<pre>public&nbsp;boolean&nbsp;isPivotTablesLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Pivot tables are locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isSortLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isSortLocked</h4>
<pre>public&nbsp;boolean&nbsp;isSortLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Sorting is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isObjectsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isObjectsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isObjectsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Objects are locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isScenariosLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isScenariosLocked</h4>
<pre>public&nbsp;boolean&nbsp;isScenariosLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Scenarios are locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isSelectLockedCellsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isSelectLockedCellsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isSelectLockedCellsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Selection of locked cells is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isSelectUnlockedCellsLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isSelectUnlockedCellsLocked</h4>
<pre>public&nbsp;boolean&nbsp;isSelectUnlockedCellsLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Selection of unlocked cells is locked and the sheet is protected.</dd></dl>
</li>
</ul>
<a name="isSheetLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>isSheetLocked</h4>
<pre>public&nbsp;boolean&nbsp;isSheetLocked()</pre>
<dl><dt><span class="strong">Returns:</span></dt><dd>true when Sheet is Protected.</dd></dl>
</li>
</ul>
<a name="enableLocking()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>enableLocking</h4>
<pre>public&nbsp;void&nbsp;enableLocking()</pre>
<div class="block">Enable sheet protection</div>
</li>
</ul>
<a name="disableLocking()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>disableLocking</h4>
<pre>public&nbsp;void&nbsp;disableLocking()</pre>
<div class="block">Disable sheet protection</div>
</li>
</ul>
<a name="lockAutoFilter()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockAutoFilter</h4>
<pre>public&nbsp;void&nbsp;lockAutoFilter()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockAutoFilter(boolean)"><code>lockAutoFilter(boolean)</code></a></i></div>
<div class="block">Enable Autofilters locking.</div>
</li>
</ul>
<a name="lockAutoFilter(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockAutoFilter</h4>
<pre>public&nbsp;void&nbsp;lockAutoFilter(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Autofilters locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockDeleteColumns()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockDeleteColumns</h4>
<pre>public&nbsp;void&nbsp;lockDeleteColumns()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteColumns(boolean)"><code>lockDeleteColumns(boolean)</code></a></i></div>
<div class="block">Enable Deleting columns locking.</div>
</li>
</ul>
<a name="lockDeleteColumns(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockDeleteColumns</h4>
<pre>public&nbsp;void&nbsp;lockDeleteColumns(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Deleting columns locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockDeleteRows()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockDeleteRows</h4>
<pre>public&nbsp;void&nbsp;lockDeleteRows()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockDeleteRows(boolean)"><code>lockDeleteRows(boolean)</code></a></i></div>
<div class="block">Enable Deleting rows locking.</div>
</li>
</ul>
<a name="lockDeleteRows(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockDeleteRows</h4>
<pre>public&nbsp;void&nbsp;lockDeleteRows(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Deleting rows locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockFormatCells()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatCells</h4>
<pre>public&nbsp;void&nbsp;lockFormatCells()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatCells(boolean)"><code>lockFormatCells(boolean)</code></a></i></div>
<div class="block">Enable Formatting cells locking.</div>
</li>
</ul>
<a name="lockFormatCells(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatCells</h4>
<pre>public&nbsp;void&nbsp;lockFormatCells(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Formatting cells locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockFormatColumns()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatColumns</h4>
<pre>public&nbsp;void&nbsp;lockFormatColumns()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatColumns(boolean)"><code>lockFormatColumns(boolean)</code></a></i></div>
<div class="block">Enable Formatting columns locking.</div>
</li>
</ul>
<a name="lockFormatColumns(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatColumns</h4>
<pre>public&nbsp;void&nbsp;lockFormatColumns(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Formatting columns locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockFormatRows()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatRows</h4>
<pre>public&nbsp;void&nbsp;lockFormatRows()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockFormatRows(boolean)"><code>lockFormatRows(boolean)</code></a></i></div>
<div class="block">Enable Formatting rows locking.</div>
</li>
</ul>
<a name="lockFormatRows(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockFormatRows</h4>
<pre>public&nbsp;void&nbsp;lockFormatRows(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Formatting rows locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockInsertColumns()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertColumns</h4>
<pre>public&nbsp;void&nbsp;lockInsertColumns()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertColumns(boolean)"><code>lockInsertColumns(boolean)</code></a></i></div>
<div class="block">Enable Inserting columns locking.</div>
</li>
</ul>
<a name="lockInsertColumns(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertColumns</h4>
<pre>public&nbsp;void&nbsp;lockInsertColumns(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Inserting columns locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockInsertHyperlinks()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertHyperlinks</h4>
<pre>public&nbsp;void&nbsp;lockInsertHyperlinks()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertHyperlinks(boolean)"><code>lockInsertHyperlinks(boolean)</code></a></i></div>
<div class="block">Enable Inserting hyperlinks locking.</div>
</li>
</ul>
<a name="lockInsertHyperlinks(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertHyperlinks</h4>
<pre>public&nbsp;void&nbsp;lockInsertHyperlinks(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Inserting hyperlinks locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockInsertRows()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertRows</h4>
<pre>public&nbsp;void&nbsp;lockInsertRows()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockInsertRows(boolean)"><code>lockInsertRows(boolean)</code></a></i></div>
<div class="block">Enable Inserting rows locking.</div>
</li>
</ul>
<a name="lockInsertRows(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockInsertRows</h4>
<pre>public&nbsp;void&nbsp;lockInsertRows(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Inserting rows locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockPivotTables()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockPivotTables</h4>
<pre>public&nbsp;void&nbsp;lockPivotTables()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockPivotTables(boolean)"><code>lockPivotTables(boolean)</code></a></i></div>
<div class="block">Enable Pivot Tables locking.</div>
</li>
</ul>
<a name="lockPivotTables(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockPivotTables</h4>
<pre>public&nbsp;void&nbsp;lockPivotTables(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Pivot Tables locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockSort()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSort</h4>
<pre>public&nbsp;void&nbsp;lockSort()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSort(boolean)"><code>lockSort(boolean)</code></a></i></div>
<div class="block">Enable Sort locking.</div>
</li>
</ul>
<a name="lockSort(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSort</h4>
<pre>public&nbsp;void&nbsp;lockSort(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Sort locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockObjects()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockObjects</h4>
<pre>public&nbsp;void&nbsp;lockObjects()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockObjects(boolean)"><code>lockObjects(boolean)</code></a></i></div>
<div class="block">Enable Objects locking.</div>
</li>
</ul>
<a name="lockObjects(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockObjects</h4>
<pre>public&nbsp;void&nbsp;lockObjects(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Objects locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockScenarios()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockScenarios</h4>
<pre>public&nbsp;void&nbsp;lockScenarios()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockScenarios(boolean)"><code>lockScenarios(boolean)</code></a></i></div>
<div class="block">Enable Scenarios locking.</div>
</li>
</ul>
<a name="lockScenarios(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockScenarios</h4>
<pre>public&nbsp;void&nbsp;lockScenarios(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Scenarios locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockSelectLockedCells()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSelectLockedCells</h4>
<pre>public&nbsp;void&nbsp;lockSelectLockedCells()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectLockedCells(boolean)"><code>lockSelectLockedCells(boolean)</code></a></i></div>
<div class="block">Enable Selection of locked cells locking.</div>
</li>
</ul>
<a name="lockSelectLockedCells(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSelectLockedCells</h4>
<pre>public&nbsp;void&nbsp;lockSelectLockedCells(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Selection of locked cells locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="lockSelectUnlockedCells()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSelectUnlockedCells</h4>
<pre>public&nbsp;void&nbsp;lockSelectUnlockedCells()</pre>
<div class="block"><span class="strong">Deprecated.</span>&nbsp;<i>use <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#lockSelectUnlockedCells(boolean)"><code>lockSelectUnlockedCells(boolean)</code></a></i></div>
<div class="block">Enable Selection of unlocked cells locking.</div>
</li>
</ul>
<a name="lockSelectUnlockedCells(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>lockSelectUnlockedCells</h4>
<pre>public&nbsp;void&nbsp;lockSelectUnlockedCells(boolean&nbsp;enabled)</pre>
<div class="block">Enable or disable Selection of unlocked cells locking.
 This does not modify sheet protection status.
 To enforce this un-/locking, call <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#disableLocking()"><code>disableLocking()</code></a> or <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheet.html#enableLocking()"><code>enableLocking()</code></a></div>
</li>
</ul>
<a name="setArrayFormula(java.lang.String, org.apache.poi.ss.util.CellRangeAddress)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setArrayFormula</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;&nbsp;setArrayFormula(java.lang.String&nbsp;formula,
                                  <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String, org.apache.poi.ss.util.CellRangeAddress)">Sheet</a></code></strong></div>
<div class="block">Sets array formula to specified region for result.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setArrayFormula(java.lang.String, org.apache.poi.ss.util.CellRangeAddress)">setArrayFormula</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>formula</code> - text representation of the formula</dd><dd><code>range</code> - Region of array formula for result.</dd>
<dt><span class="strong">Returns:</span></dt><dd>the <a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel"><code>CellRange</code></a> of cells affected by this change</dd></dl>
</li>
</ul>
<a name="removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>removeArrayFormula</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel">CellRange</a>&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCell.html" title="class in org.apache.poi.xssf.usermodel">XSSFCell</a>&gt;&nbsp;removeArrayFormula(<a href="../../../../../org/apache/poi/ss/usermodel/Cell.html" title="interface in org.apache.poi.ss.usermodel">Cell</a>&nbsp;cell)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">Sheet</a></code></strong></div>
<div class="block">Remove a Array Formula from this sheet.  All cells contained in the Array Formula range are removed as well</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#removeArrayFormula(org.apache.poi.ss.usermodel.Cell)">removeArrayFormula</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>cell</code> - any cell within Array Formula range</dd>
<dt><span class="strong">Returns:</span></dt><dd>the <a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel"><code>CellRange</code></a> of cells affected by this change</dd></dl>
</li>
</ul>
<a name="getDataValidationHelper()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataValidationHelper</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/usermodel/DataValidationHelper.html" title="interface in org.apache.poi.ss.usermodel">DataValidationHelper</a>&nbsp;getDataValidationHelper()</pre>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidationHelper()">getDataValidationHelper</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
</dl>
</li>
</ul>
<a name="getDataValidations()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataValidations</h4>
<pre>public&nbsp;java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFDataValidation.html" title="class in org.apache.poi.xssf.usermodel">XSSFDataValidation</a>&gt;&nbsp;getDataValidations()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">Sheet</a></code></strong></div>
<div class="block">Returns the list of DataValidation in the sheet.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getDataValidations()">getDataValidations</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>list of DataValidation in the sheet</dd></dl>
</li>
</ul>
<a name="addValidationData(org.apache.poi.ss.usermodel.DataValidation)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>addValidationData</h4>
<pre>public&nbsp;void&nbsp;addValidationData(<a href="../../../../../org/apache/poi/ss/usermodel/DataValidation.html" title="interface in org.apache.poi.ss.usermodel">DataValidation</a>&nbsp;dataValidation)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">Sheet</a></code></strong></div>
<div class="block">Creates a data validation object</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#addValidationData(org.apache.poi.ss.usermodel.DataValidation)">addValidationData</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>dataValidation</code> - The Data validation object settings</dd></dl>
</li>
</ul>
<a name="setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAutoFilter</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFAutoFilter.html" title="class in org.apache.poi.xssf.usermodel">XSSFAutoFilter</a>&nbsp;setAutoFilter(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;range)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">Sheet</a></code></strong></div>
<div class="block">Enable filtering for a range of cells</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setAutoFilter(org.apache.poi.ss.util.CellRangeAddress)">setAutoFilter</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>range</code> - the range of cells to filter</dd></dl>
</li>
</ul>
<a name="createTable()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createTable</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFTable</a>&nbsp;createTable()</pre>
<div class="block">Creates a new Table, and associates it with this Sheet</div>
</li>
</ul>
<a name="getTables()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getTables</h4>
<pre>public&nbsp;java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFTable</a>&gt;&nbsp;getTables()</pre>
<div class="block">Returns any tables associated with this Sheet</div>
</li>
</ul>
<a name="getSheetConditionalFormatting()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getSheetConditionalFormatting</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheetConditionalFormatting.html" title="class in org.apache.poi.xssf.usermodel">XSSFSheetConditionalFormatting</a>&nbsp;getSheetConditionalFormatting()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">Sheet</a></code></strong></div>
<div class="block">The 'Conditional Formatting' facet for this <tt>Sheet</tt></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getSheetConditionalFormatting()">getSheetConditionalFormatting</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>conditional formatting rule for this sheet</dd></dl>
</li>
</ul>
<a name="setTabColor(int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setTabColor</h4>
<pre>public&nbsp;void&nbsp;setTabColor(int&nbsp;colorIndex)</pre>
<div class="block">Set background color of the sheet tab</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>colorIndex</code> - the indexed color to set, must be a constant from <a href="../../../../../org/apache/poi/ss/usermodel/IndexedColors.html" title="enum in org.apache.poi.ss.usermodel"><code>IndexedColors</code></a></dd></dl>
</li>
</ul>
<a name="getRepeatingRows()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRepeatingRows</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;getRepeatingRows()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">Sheet</a></code></strong></div>
<div class="block">Gets the repeating rows used when printing the sheet, as found in 
 File->PageSetup->Sheet.
 <p/>
 Repeating rows cover a range of contiguous rows, e.g.:
 <pre>
 Sheet1!$1:$1
 Sheet2!$5:$8
 </pre>
 The <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> returned contains a column part which spans 
 all columns, and a row part which specifies the contiguous range of 
 repeating rows.
 <p/>
 If the Sheet does not have any repeating rows defined, null is returned.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingRows()">getRepeatingRows</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>an <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> containing the repeating rows for the 
         Sheet, or null.</dd></dl>
</li>
</ul>
<a name="getRepeatingColumns()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRepeatingColumns</h4>
<pre>public&nbsp;<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;getRepeatingColumns()</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">Sheet</a></code></strong></div>
<div class="block">Gets the repeating columns used when printing the sheet, as found in 
 File->PageSetup->Sheet.
 <p/>
 Repeating columns cover a range of contiguous columns, e.g.:
 <pre>
 Sheet1!$A:$A
 Sheet2!$C:$F
 </pre>
 The <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> returned contains a row part which spans all 
 rows, and a column part which specifies the contiguous range of 
 repeating columns.
 <p/>
 If the Sheet does not have any repeating columns defined, null is 
 returned.</div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#getRepeatingColumns()">getRepeatingColumns</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Returns:</span></dt><dd>an <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> containing the repeating columns for 
         the Sheet, or null.</dd></dl>
</li>
</ul>
<a name="setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRepeatingRows</h4>
<pre>public&nbsp;void&nbsp;setRepeatingRows(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;rowRangeRef)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">Sheet</a></code></strong></div>
<div class="block">Sets the repeating rows used when printing the sheet, as found in 
 File->PageSetup->Sheet.
 <p/>
 Repeating rows cover a range of contiguous rows, e.g.:
 <pre>
 Sheet1!$1:$1
 Sheet2!$5:$8</pre>
 The parameter <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> should specify a column part 
 which spans all columns, and a row part which specifies the contiguous 
 range of repeating rows, e.g.:
 <pre>
 sheet.setRepeatingRows(CellRangeAddress.valueOf("2:3"));</pre>
 A null parameter value indicates that repeating rows should be removed 
 from the Sheet:
 <pre>
 sheet.setRepeatingRows(null);</pre></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingRows</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>rowRangeRef</code> - a <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> containing the repeating 
        rows for the Sheet, or null.</dd></dl>
</li>
</ul>
<a name="setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRepeatingColumns</h4>
<pre>public&nbsp;void&nbsp;setRepeatingColumns(<a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util">CellRangeAddress</a>&nbsp;columnRangeRef)</pre>
<div class="block"><strong>Description copied from interface:&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">Sheet</a></code></strong></div>
<div class="block">Sets the repeating columns used when printing the sheet, as found in 
 File->PageSetup->Sheet.
 <p/>
 Repeating columns cover a range of contiguous columns, e.g.:
 <pre>
 Sheet1!$A:$A
 Sheet2!$C:$F</pre>
 The parameter <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> should specify a row part 
 which spans all rows, and a column part which specifies the contiguous 
 range of repeating columns, e.g.:
 <pre>
 sheet.setRepeatingColumns(CellRangeAddress.valueOf("B:C"));</pre>
 A null parameter value indicates that repeating columns should be removed 
 from the Sheet:
 <pre>
 sheet.setRepeatingColumns(null);</pre></div>
<dl>
<dt><strong>Specified by:</strong></dt>
<dd><code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html#setRepeatingColumns(org.apache.poi.ss.util.CellRangeAddress)">setRepeatingColumns</a></code>&nbsp;in interface&nbsp;<code><a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a></code></dd>
<dt><span class="strong">Parameters:</span></dt><dd><code>columnRangeRef</code> - a <a href="../../../../../org/apache/poi/ss/util/CellRangeAddress.html" title="class in org.apache.poi.ss.util"><code>CellRangeAddress</code></a> containing the repeating 
        columns for the Sheet, or null.</dd></dl>
</li>
</ul>
<a name="createPivotTable(org.apache.poi.ss.util.AreaReference, org.apache.poi.ss.util.CellReference, org.apache.poi.ss.usermodel.Sheet)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createPivotTable</h4>
<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation in org.apache.poi.util">@Beta</a>
public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                                   <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;position,
                                   <a href="../../../../../org/apache/poi/ss/usermodel/Sheet.html" title="interface in org.apache.poi.ss.usermodel">Sheet</a>&nbsp;sourceSheet)</pre>
<div class="block">Create a pivot table and set area of source, source sheet and a position for pivot table</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - Area from where data will be collected</dd><dd><code>position</code> - A reference to the cell where the table will start</dd><dd><code>sourceSheet</code> - The sheet where source will be collected from</dd>
<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
</li>
</ul>
<a name="createPivotTable(org.apache.poi.ss.util.AreaReference, org.apache.poi.ss.util.CellReference)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>createPivotTable</h4>
<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation in org.apache.poi.util">@Beta</a>
public&nbsp;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&nbsp;createPivotTable(<a href="../../../../../org/apache/poi/ss/util/AreaReference.html" title="class in org.apache.poi.ss.util">AreaReference</a>&nbsp;source,
                                   <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a>&nbsp;position)</pre>
<div class="block">Create a pivot table and set area of source and a position for pivot table</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>source</code> - Area from where data will be collected</dd><dd><code>position</code> - A reference to the cell where the table will start</dd>
<dt><span class="strong">Returns:</span></dt><dd>The pivot table</dd></dl>
</li>
</ul>
<a name="getPivotTables()">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>getPivotTables</h4>
<pre><a href="../../../../../org/apache/poi/util/Beta.html" title="annotation in org.apache.poi.util">@Beta</a>
public&nbsp;java.util.List&lt;<a href="../../../../../org/apache/poi/xssf/usermodel/XSSFPivotTable.html" title="class in org.apache.poi.xssf.usermodel">XSSFPivotTable</a>&gt;&nbsp;getPivotTables()</pre>
<div class="block">Returns all the pivot tables for this Sheet</div>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/XSSFSheet.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFShapeGroup.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/xssf/usermodel/XSSFSheetConditionalFormatting.html" title="class in org.apache.poi.xssf.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/xssf/usermodel/XSSFSheet.html" target="_top">FRAMES</a></li>
<li><a href="XSSFSheet.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
